Importing your bank statement into QuickBooks
Reconciling your bank statement at the end of the month is a task every business owner must carry out if they truly want to understand the state of their cash flow in QuickBooks. But a major challenge is when you have several banks with a large volume of transactions available for manual review before reconciliations, how do you intend to carry this out?
This review highlights a financial solution that will help imports bank statement into your QuickBooks financial software.
Though we are still expanding the application to accommodate all bank extension but for now, you can only import bank transaction statement using GTB format. What this means is that any time you want to import a bank statement that is not from GTB, you need to re-format your excel column to correspond with the standard format built into the application.
Importing your banking statement into QuickBooks:
I: This guide contains basic pictorial steps to import your bank statement into QuickBooks.
When you launch the application, here is how the window looks like with relevant label and their respective descriptions.
A: This label shows all the banks from which you select the bank account you want to import your statement.
B: Here you select the period within which all transactions in your statement falls in.
C: Bank Statement: This is the button that lets you upload bank statement from your computer.
You need to follow the pre-built format acceptable by the application before it can successful import your bank statement in QuickBooks.
D: The “Get Template” explains how the format of the bank statement is expected to be, in columns, before you can easily import into QuickBooks.
E: This is where you check all transactions fields imported for accuracy.
F: The “Green” and “Red” colour signify any error or show that your column is valid after importing the bank statement.
II: How to import your bank statement.
- On the home screen, click label A, B and use C to load the statement as shown in the snapshot above.
- Follow the guide on the snapshot below:
- A: Select the sheet name “Bank Statement Import”. On your spreadsheet, you will see the name at the footer section.
- B: Load data lets you import the statement shown below in excel format.
- C: Use the “Check Data” to verify your import for error.
- D: This indicates successful transactions
- E: This indicate areas you should correct
Once all errors are resolved, the save button appears for you to click and run the import.
Note: If there is any payment on the statement without a corresponding invoice, QuickBooks will give the customer a credit which can only be cleared by either a refund or subsequent invoice issued to the customer.
III – Check your bank register to see the transaction imported
- Go to Banking > Use Register
- Select GTB
While this is the first product available, we are still working on extending the application to work with other bank’s statement file.