We recently added the ability to import your bank transactions into QuickBooks Online as checks and deposits in one import. If you do not see this import type available to you in our Transaction Pro Importer (“TPI”) make sure you are on the latest App which can be accessed here. If you are using QuickBooks Desktop please refer to our bank statement import article here.
Below we will include some information on all the fields supported but I would also like to point out some important formatting considerations when preparing your file for import.
- Deposits should be expressed as positive numbers and checks as negative numbers
- There is no requirement to have a value mapped to the QuickBooks field, RefNumber, as when the bank statement import type is selected each line of the import file is treated as a unique transaction (eg no split transactions).
- The value mapped to the QuickBooks field, Entity, must exist in QuickBooks Online as either a customer, vendor or employee. TPI does not create new list items on this import type.
- Make sure that your import file only includes the lowest sub-account number (and then check the TPI option to enable account numbers) or use the full account name. Read more on our knowledge base.
Below are all the fields supported on the Bank Statement Import to QuickBooks Online. You can also access this from within the TPI App here.
We have had a lot of interest in this import type so we hope you will check it out and let us know if you have any feedback.