Child pages
  • Why is my bank balance different to my MYOB Essentials balance?


 

 

Close

How satisfied are you with our online help?*

Just these help pages, not phone support or the product itself

0
1
2
3
4
5
Very dissatisfied
Very satisfied

Why did you give this rating?

Anything else you want to tell us about the help?

If you have a bank or credit card account linked to MYOB Essentials Accounting via a bank feed, ideally the Essentials account will match the bank account. But sometimes you may notice a difference between the two balances displayed on the MYOB Essentials Dashboard.

For credit card accounts, this will appear on the Dashboard as a difference between the MYOB Essentials Accounting balance and the amount owing on the credit card.

These balances can vary because the MYOB Essentials Accounting balance is made up of all transactions for that account - including bank feed transactions not yet allocated.

Bank and credit card account balances might differ from the balance in MYOB Essentials Accounting because of the following reasons:

 

Incorrectly allocated invoices or bills

Incorrectly allocated invoices or bills

This is the most common reason for a discrepancy between your balances. This scenario typically looks like this:

  1. Let's say you record an invoice for $20.
  2. You then manually enter the payment for the $20.
  3. The $20 payment is then also presented via your bankfeed.
  4. Instead of matching the bank feed payment to the payment you entered, you allocate the bank feed transaction to an income account, e.g. sales. This will result in an additional $20 in your bank account which should not be there.

To correct this issue, these transactions need to be found, unallocated from the income account, then matched to the payment transaction.

Incorrect opening balance

Incorrect opening balance

It's important to record the correct bank account opening balance as at the date you start entering transactions in MYOB Essentials Accounting.

For example if you decide to start entering transactions in MYOB Essentials Accounting from September 2nd onwards, enter the opening balance for your accounts (from a bank statement) as at September 2nd.

To enter an opening balance:

  1. Click your business name (in the top-right corner of any page in MYOB Essentials Accounting), then click Accounts list.
  2. In the accounts list, find the account you want to enter an opening balance for.
  3. Place the cursor in the Opening balance column of the account.
  4. Enter the opening balance for this account.
    Note: Enter opening balances as positive numbers. Don't, for example, enter your liability account balances as negative numbers. Enter negative amounts only if accounts truly have negative balances. As a rule, these will be asset accounts that record accumulated depreciation.
  5. If you want, click in the Account Name column and edit the name of the account.
  6. Click Save to save your changes.

Need to change a previously entered opening balance? See Entering opening balances.

Future-dated transactions

Future-dated transactions

Recording a future-dated transaction will also affect the MYOB Essentials Accounting balance that is displayed on the Dashboard.

To find a future-dated transaction:

  1. Go to the Banking menu and click Transaction history.
  2. In the Account field, select the appropriate bank account.
  3. In the From and To fields, select a date range from today's date to a date in the future (for example 31/12/2020).
  4. Click Update.
  5. Any future-dated transactions will be displayed in the transactions list. You can then click into the transaction to correct the date and save it.
Not all transactions can be saved when changed, such as reconciled transactions. Only transactions with a Save button at the bottom of the transaction detail screen can be saved. For a transaction that can't be saved, delete the transaction and re-enter it with the correct date.
Missing bank feed transactions

Missing bank feed transactions

If you have a bank account linked to MYOB Essentials Accounting, it's possible (although quite rare) for bank transactions to be missing.

You can check this as follows:

  1. Go to the Banking menu and click Bank transactions.
  2. Click Import History.
  3. Select the appropriate bank account from the dropdown list and the dates of each bank feed will be displayed. If your bank sends your transactions daily, you should be looking for any gaps in the dates; noting banks don't provide data on weekends. If you find a gap, we suggest you check if there were any transactions on that day on a bank statement or via your bank's own internet banking. If you find any missing transactions, the easiest fix is to enter them manually (via Spend Money/Receive Money or Enter Customer Payment/Enter Supplier Payment) or by exporting the transactions to a QIF file from your online banking and then importing them into MYOB Essentials Accounting.

If all else fails...

If you're still having problems finding the difference between your bank balances, the definitive resolution is:

  1. Make sure all transactions for the relevant account have been allocated or matched. This means there will be no transactions on the Banking page appearing as Allocate Me.
  2. Go to the Reports menu then click the Banking Transactions report.
  3. Leave the Contact field as All, and select the required bank account from the Account drop down list.
  4. Specify a wide date range like 01/01/2000 to 31/12/2020 and leave all other fields blank.
  5. Click Generate report. Depending on the number of transactions you have, this report may take a while to generate.
  6. Print the generated report and compare the transactions on the report to the transactions on your bank statement(s). You will find a transaction that appears on one but not the other.
  7. You can then resolve the discrepancy by either adding or deleting the offending transaction(s) in MYOB Essentials Accounting.
  8. If necessary, eg. due to bank rounding, you can re-enter the transaction to ensure the amount matches what appeared in the bank feed.