Share this content

Exporting Quickbooks data to Viztopia/Excel

Exporting Quickbooks data to Viztopia/Excel

Didn't find your answer?

I would like to export Quickbooks data (not just the trial balance)to Viztopia. The first stage is to get it into suitable format in Excel. Although Quickbooks will happily export a particular report to excel will it export a simple list of all transactions in debit/credit fashion? Does Quickbooks use account numbers or ONLY names?
Laurence Golend

Replies (3)

Please login or register to join the discussion.

avatar
By cbales
29th Nov 2002 19:07

"Split" entries
Laurence
Happens primarily in the bank and cash account type registers and the accounts payable (bought ledger control) and accounts receivable (sales ledger control).

Three ways of dealing with this -
1) Use the print button at the top of the register screen which will take you to the date selection window and check the "print split details" checkbox. Printouts and screen views will then show the full detail of the split entries. For transer from here to Excel, use print to file selecting comma delimited and click on OK. Open Excel and then import the file into Excel.

2) In the Pro and Premier versions of the software, from the general ledger reports (Nominal ledger), click on the Excel button to bring up the window for selection of a new workbook or to open an existing workbook. Then click on the advanced button and check the "Auto Outline (allows collapsing expanding)" and the "Auto Filtering (allows custom data filtering)" buttons if neither is already ticked. This will include the collapse/expand facility within the spreadsheet and the auto filtering buttons at the head of each column. Then click on OK to transfer to Excel. In Excel, page across to the "splits" column and select bank accounts, accounts receivable and accounts payable as required to show the detail.

3) The easiest but entails entering a lot more detail in the first place. Enter each part of split transactions as a separate transaction so that the use of the split routine is unnecessary. If payroll is in use this would add a significant amount of extra entry work.

Hope this deals with the matter.

Thanks (0)
avatar
By acca_Laurence
29th Nov 2002 13:42

Useful but......
The information re account numbers is very useful.
However a further problem seems to be split entries which are merely reported as SPLIT

Thanks (0)
avatar
By cbales
25th Nov 2002 20:23

Laurence
Account numbers can be set up by selecting the relevant checkbox in preferences for the client. Go to edit menu, preferences, select accounting in the pane on the left and, on the company preferences tab, click on use account numbers. Account numbers can then be set up against the account titles.

Use Excel to quickly and easily produce reports in debit and credit format from any report exported from QuickBooks in single column format. Set up a template to do it with utilising in-built conditional formulae and just copy the single column report imported from QuickBooks onto it.

Thanks (0)
Share this content