Importing from quickbooks (all transactions)

[QFMathew]

Hi @witchway

The quickest way to import your figures is to download a trial balance report and upload it into QuickFile which is good to do at the end of an accounting year. I’ve included a few links below which may help.

Importing data from another system

Introduction When migrating to QuickFile from another accounts package you may need to consider how you will bring across the data stored there. This guide will discuss 3 methods for importing data. You can also use our interactive questionnaire here to point you in the right direction. Unless you have a very new company you don’t want to go back and import every single invoice and bank transaction. Importing Opening Balances is the quickest way to get started on QuickFile. Most accounting app…

Importing a Quick Books Trial Balance

The Trial Balance report shows the total value of all of your credit and debit entries. Here we'll explain briefly how you can get a copy of your Trial Balance from Quickbooks Desktop software ready for import into QuickFile. Log onto your Quick Books Software. Go to the ‘Reports’ menu on the tool bar and select ‘Accountant & Taxes’ from the drop down list. [image] Now click ‘Trial Balance’. [image] The Trial Balance report will appear on the screen. Have a look over the Trial Balance and …

A trial balance would include figures at a specific date. So if you export it, for example, for 31st October 2017, then this will include all invoices and purchases up to that date.

In regards to invoices, if you did want to input your invoices directly, then there are two main options:

1. Importing a bank statement and tagging them, creating invoices as you go. This guide should help you with this

2. Importing a .csv file, which you should be able to download from QuickBooks to import into QuickFile. This guide should help.

Just remember not to duplicate the data by importing both invoices and a trial balance covering the same date range. Although you are welcome to use both methods, e.g. a trial balance up to 31st October, and invoices from 1st November, to bring your QuickFile account up to date.

I hope that makes sense, but please let us know if we can help further