Lumary AH - This article will provide the steps to find and upload your bank statement for a specific period, and begin the process of matching transactions to invoices.
This feature currently does not handle transactions from credit card payment gateways or refund transactions. These transactions should be ignored in the matching process and handled manually.
To perform bank reconciliation using Lumary:
- Download a CSV from your Bank Account -
- CommBiz - https://www.commbank.com.au/support.business.commbiz.export-transactions.html
- NAB - https://www.nab.com.au/business/online-banking/nab-connect/help/reports/balances-transactions/account-transaction-reports
- ANZ - https://www.anz.com.au/support/view-or-dispute-transactions/
- Westpac - https://www.westpac.com.au/faq/business-how-export-detailed-transaction-history/
- Suncorp - https://www.suncorpbank.com.au/help-support/faqs/business-banking/internet-banking/transaction-information-for-accounting-software.html#transaction-information-for-accounting-software
- Go to the Bank Statement screen -
- Use the App Launcher to navigate to the Bank Statement tab.
- This screen will allow you to access previous uploads of the Bank Statement and upload a new bank statement.
- Upload the CSV -
- Click the Upload New Bank Statement button on the right.
- Choose the file downloaded from the bank.
- Click Next
- Mapping Columns from CSV to Lumary Statement Fields:
-
- Select the corresponding fields from the system to map your statement CSV to -
- Transaction Amount - Map to Debit and or Credit columns
- Transaction Description - Map to the Description column
- Transaction Reference - Map to the separate Reference column
- Transaction Date - Map to the date of the Transaction column
- Click Next.
- Select the corresponding fields from the system to map your statement CSV to -
- The statement will now upload with the provided mapping.
- Click Done and the Bank Statement will be available in the Bank Statement list.