Solved

Quickbooks - exporting to Excel or CSV

Posted on 2016-09-01
3
24 Views
Last Modified: 2016-09-07
If I export data to excel and I have a deposit that had multiple entries. The deposit shows "split" on the Excel sheet.
This causes a huge amount of work associating the "split" to the correct ledger numbers.
I want the corresponding entries to export together. Or is there another way to get at the data?
0
Comment
Question by:DAveB_LDS
  • 2
3 Comments
 
LVL 19
ID: 41781922
In Excel, you can use the Subtotal feature to add the split entries. This may do what you need.

1. Select the data and choose Subtotal in the Outline group of the DATA ribbon
Subtotal step 12. Collapse to the desired level (2 in my example) to show the information that you want
Subtotal step 23. Copy the Visible cells and paste to another sheet for exporting (I have shown it on the same sheet)
Subtotal step 3
0
 

Accepted Solution

by:
DAveB_LDS earned 0 total points
ID: 41781995
Thank you for your help.
I found another report "Journal" which shows all of the debits and credits for each entry.
That will work.

Then I can import and process the data in a real tool (Access) and come up with my desired results.
0
 

Author Closing Comment

by:DAveB_LDS
ID: 41787488
I don't think  the suggested one would work for my data
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question