Using Breeze, you can upload bank statement files and the system will automatically match transactions on the bank statement with Breeze transactions: checks, deposits, and journal entries. This functionality on the Bank Reconciliation screen is called "Load File."
Breeze accepts the following bank file formats: QFX and BAI2. For QFX files, use the .qfx extension. For BAI2 files, use .txt as the extension.
Typically, you can download statement files from your bank's website. For more information about this step, contact your bank.
To use a bank file in a bank reconciliation
Go to Accounting > Banking > Bank Reconciliation.
Select the Bank.
Enter the Bank Statement Date, and the Ending Balance per Bank Statement.
Click Load File.
A popup window appears.
You can drag and drop the bank file to the popup window, or you can click Choose File and browse to the location of the bank file.
Breeze loads the file and displays the Bank Reconciliation screen.
In the lower half of the screen, you can see the transactions that have been matched.
For matched transactions, the Clear Date comes from information in the file. If the date is blank in the file, Breeze will use the Bank Rec date.
To see unmatched transactions, click View Report and select Not Matched.
In this example, the report shows that there are two adjustments in the bank statement file that were not matched to Breeze transactions.
Unmatched adjustments are typically transactions that were created by the bank; for example, adjustments for fees and/or interest payments. These transactions are not recorded in Breeze before you get the statement because you don't know what the amounts will be.
In the Bank Reconciliation screen, click the Add Journal button and create a journal entry.
In the detail section, there are lines for the bank fee and the interest payment. The fee is $5 -- a debit to the Bank Fees account and a Credit to Cash. The 3.53 interest payment is the opposite -- a Credit to the Bank Interest Account and a Debit to Cash. The Net amount to Cash is a credit of 1.47.
After you save the journal entry, it appears on the Bank Reconciliation screen.
On the Bank Reconciliation screen, when a single journal entry has multiple line items to cash, Breeze nets the amounts. If you want to see distinct amounts, you need to add two (or more) journals.
Select the check box to clear the journal entry.
At the top of the screen, you can see that the Difference is now zero, and you can post the bank rec.
