When you are fully coded and matched, your Farm Focus balance should be the same as your bank balance. If you use bank feeds you should always be balanced providing your coding is up-to-date and you have not duplicated or deleted any bank transactions.
The account balance in Farm Focus is reconciled to your bank account balance each day in the Balancing page, which makes it easy to pinpoint when the account may have become unbalanced.
Before you prepare a GST return, always check you are balanced to the GST period end date.
The Balancing page
Shows you are on the Balancing page
Shows the financial year
Shows the bank account the balancing refers to
The green line shows you where you're balanced too
Balanced amount - note it is single figure in black text
Farm Focus Balance - note it is red and does not balance your bank balance
Bank Balance - note it is red and does not balance your Farm Focus balance
Shows this transaction is coded - if it was uncoded it would have a blue token saying
Shows it is a manual entry - if a bank feed had been used it would say Bank feed
Select these 3 vertical dots to view the transaction
Use the drop-down arrow to view the details of the month
Your farm business could be unbalanced because:
The opening balance entered for your farm business may be incorrect.
Un-coded transactions are sitting in the Needs Action tab of the Actuals screen that are dated on or before the bank account balance date. This is the primary reason an account is unbalanced.
There are duplicate transactions (recorded more than once). If so, remove any transactions that don't belong to the bank account.
Transactions have been accidentally deleted.
You have a manual bank account and need to enter a closing balance each month.
Other - What else can cause an unbalanced account?
1. Opening balance
Go to Settings > Bank Accounts.
Check the opening balance and the date shown against your bank statement.
If the opening balance is incorrect, re-type the opening balance into the opening balance field.
2. Uncoded transactions
Uncoded transactions are easily identified by the blue Uncoded token.
Click on the 3 vertical dots on the transaction line and select View Transaction.
Code the transaction as per normal.
Once coded the Farm Focus balance will up-date.
2. Duplicate transactions
To delete duplicate transactions:
In the Balancing page - click the 3 vertical dots on the transaction line.
Select Delete.
3. Transactions have been deleted
Click on the Deleted tab and locate the deleted transaction.
Select the 3 vertical dots. Click Restore transaction.
4. Enter a closing balance on a manual bank account
For manual bank accounts, where the transactions are imported as a CSV or QIF file, the closing balance will need to be entered manually on the last day of the month.
Check your bank to confirm the month's closing balance.
Type the balance into the Bank Balance field.
5. What else can cause an unbalanced account?
Journal entries
You may have created a transaction in Farm Focus that doesn’t appear in your bank account. For example, you want to claim the GST for a business-related item that was paid for from your personal account. These are called journal entries. Journal entries should not change your bank balance as the total transaction should equal $0.00. Click here to learn more about journal entries.
Pending transactions do not appear in daily bank balance
When using bank feeds, on rare occasions, pending transactions may not appear in your daily bank balance. This corrects itself the next day but in your balancing page the bank balance will not match your Farm Focus balance for that particular day. If this occurs, you are able to manually correct the bank balance for that day. This feature should be used with caution and is the exception and not the normal.
Rabobank All In One account.
Rabobank All In One accounts combine your everyday banking with loan facilities.
The Bank balance displayed in the Focus balancing screen is fed directly into your farm business from Rabobank. This is a combined total including loan facilities
NOTE: You can manually adjust the bank account balance to exclude your loan facilities. Find out moreThe Focus balance refers to cash movement only. For more information please visit the Rabobank website
More Information