Summary
How to create Bank Rules to save more time, and reduce the risk of errors while performing bank reconciliations in Sage 50 Canadian Edition.
Resolution
- On the Banking tab, go to Match Bank Transactions, Match Transactions.
- Click on Bank Rules and Create Rule.
- Fill out the necessary fields to create a new bank rule. Enter a description, confirm it applies to the right bank and whether it should apply when it goes in or out. You can set this up for monthly statement fees, recurring set amounts or transactions on particular days. Sage banking service will apply the relevant bank rule to transactions using the conditions entered.
- Confirm or choose the transaction type, enter a source code for the transaction and or select: the relevant expense account, the account the transaction is being charged from and whether or not to have a custom comment or use the bank's description of the transaction.
- Manage your bank rules, by clicking on Bank Rules > Manage Bank Rules. This allows you to edit, delete or copy saved bank rules.
- Option: Create transactions from uploaded bank statements if not using bank feeds. On the match transaction window click on "Upload to Bank Services." Enter new bank account details or enter existing bank details.
- Select the option for the file format that you are importing, select or drag and drop the relevant bank statement file. Choose the option for display of dates, enter a comment and click upload.
- This window will ask you to review the transactions in the bank statement as money going in or out. Click Verify.
- Review the transactions and click "Import Transactions".
- Once the transactions are imported, you can set up bank rules to apply them to the currently imported transactions and or future ones brought into the bank.
DocLink: How do I remove a Bank Feeds connection?
DocLink: How do I setup Sage Bank Feeds?