Uploading a bank statement

AR Management - 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.

Bank statements can be downloaded from your bank account for a given period, uploaded into Lumary and auto-matched to outstanding invoices.

Required packages and permissions

Available with:  Lumary 22.82 and later

Permission: Lumary AR - AR Management & Lumary AR - EFT Matching

Lumary AR Management features do not necessarily come as standard. If these features are not available to your users, please contact your Account Manager.

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.

The process of performing Bank Reconciliation using Lumary is as follows:

1. Downloading 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
2. In Lumary, navigate to the Bank Statement screen:
   1. Use the App Launcher to navigate to the AR Management tab.
   2. Scroll to Bank Statement Matching, click Upload Bank Statement.
      
   3. This screen will allow you to access previous Bank Statement uploads and upload a new Bank Statement.
      
3. Uploading CSV:
   1. Click the Upload New Bank Statement button on the right.
   2. Choose the file downloaded from the bank.
   3. Click Next
   4. 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
4. The statement will now upload with the provided mapping.
5. Click Done and the Bank Statement will be available in the Bank Statement list.