Common MYOB Reconciliation Problems and How to Fix Them

You open MYOB to run your month-end reports, and the bank balance is wrong. Not by a few dollars. By hundreds. Maybe thousands.

This isn't a theoretical problem. It's the kind of thing that stops you mid-task and sends you down a rabbit hole of transaction searches, wondering if you've missed something critical or if there's a bigger issue lurking in your books.

The good news? Most MYOB reconciliation problems come from a handful of common causes. Once you know what to look for, you can find the issue, fix it, and put systems in place so it doesn't happen again.

This guide walks you through the exact diagnostic steps to track down discrepancies and the prevention strategies that keep your numbers clean.

The Panic of Mismatched Numbers

Picture this: it's the last day of the month, and you need to send financial reports to your accountant. You pull up MYOB, check your bank account balance, and it's off by $2,400.

Your first thought: did I miss a payment? Is there fraud? Are my reports going to be completely wrong?

The stress is real because the consequences are real. When your MYOB numbers don't match your bank, you can't trust your reports. And when you can't trust your reports, you make decisions based on faulty information. Data integrity issues lead to inaccuracies in reports, resulting in misguided decisions and financial losses.

Here's the reassurance: most mismatches aren't fraud. They're not even particularly complicated. They're usually caused by timing differences, duplicate entries, or small fees you haven't recorded. Fixable problems.

The 5 Most Common Reasons Your MYOB and Bank Don't Agree

Think of this as your diagnostic checklist. Most discrepancies fall into one of these five categories, which means you can work through them systematically instead of randomly clicking through transactions hoping something jumps out.

It's worth noting that common threats to data integrity include errors in data entry, duplicated data, and lack of timely updates. These aren't exotic problems. They're the everyday issues that create mismatches.

Timing Differences: Transactions in Transit

You write a cheque on the 28th. You record it in MYOB on the 28th. The supplier doesn't cash it until the 5th of next month.

Your MYOB balance reflects the payment. Your bank balance doesn't. That's a timing difference.

Other examples: electronic payments that take 2-3 business days to clear, deposits you've made that haven't hit your account yet, direct debits scheduled but not yet processed.

This isn't an error. It's normal. But you need to account for it during reconciliation. The key is recognising that these transactions will clear, they just haven't yet.

Duplicate Entries from Bank Feeds

Bank feeds are brilliant until they're not. The most common problem: you manually enter a transaction, then your bank feed pulls it in automatically, and now it's in MYOB twice.

The telltale sign? Your discrepancy is exactly double a recent transaction amount. If you're out by $850 and you recently paid an $850 invoice, start there.

The fix is straightforward: search for the transaction in MYOB, identify the duplicate, and delete it. Just make sure you're deleting the duplicate, not the original.

Unrecorded Bank Fees and Interest

Your bank deducts fees automatically. Monthly account fees. Transaction charges. Merchant fees. They also add interest, though that's usually a smaller number.

None of these appear in MYOB unless you manually enter them.

Individually, they're small. A $15 account fee here, a $3 transaction charge there. But they add up, and if you're not recording them, you'll have a persistent discrepancy that grows each month.

The solution: review your bank statement for any fees or interest, then create corresponding entries in MYOB. Do this monthly, and it becomes a quick task rather than a forensic exercise.

Manual Entry Errors and Typos

You're entering an invoice for $1,250. You type $1,520. Or you put the decimal point in the wrong place and record $125 instead of $1,250.

Manual data entry processes are error-prone and lead to data integrity issues. This isn't about being careless. It's about being human. Typos happen.

The problem is that even small errors create large discrepancies that are hard to spot. If you're out by $270, you're not looking for a $270 transaction. You're looking for a transaction where you transposed numbers or misplaced a decimal.

Don't beat yourself up about this. Just build in systematic checking.

Uncategorised or Mismatched Transactions

Your bank feed pulls in transactions, but they sit in the 'uncategorised' queue waiting for you to match them to MYOB entries or create new ones.

While they're sitting there, they affect your bank balance in MYOB, but they're not properly recorded in your accounts. Or worse, you match a bank transaction to the wrong MYOB entry, and now your numbers are off in multiple places.

Check your bank feed matching screen for pending items. Clearing this queue should be part of your regular reconciliation routine, not something you do when you notice a problem.

How to Track Down the Exact Discrepancy

Once you know what to look for, you need a systematic process to find it. Random searching doesn't work. You'll waste hours and still miss the problem.

Inadequate data auditing results in unnoticed errors, so these checks aren't optional. They're how you catch problems before they compound.

Run a Bank Reconciliation Report in MYOB

Start here: Banking > Reconcile Accounts > select your bank account > Reconciliation Report.

The report shows you three critical things: unreconciled transactions, opening and closing balances, and any discrepancies between what MYOB thinks your balance is and what your bank statement says.

Compare the 'Statement Balance' in MYOB with your actual bank statement balance. If they don't match, the 'Unreconciled Transactions' section is where you'll find most of your problems.

This report is your starting point. Everything else flows from here.

Compare Transaction Dates, Not Just Amounts

Matching amounts alone isn't enough. A $500 payment on the 15th is not the same as a $500 payment on the 22nd, even if they're to the same supplier.

Look for patterns. If all your discrepancies are from the last few days of the month, they're probably just pending transactions that haven't cleared yet.

MYOB might show a transaction dated the 15th, but your bank statement shows it clearing on the 17th due to processing delays. That's normal. Just don't mark it as reconciled until the dates align.

Check for Reversed or Deleted Entries

Deleted or reversed transactions don't show up in your normal reports, but they absolutely affect your balances.

Go to Reports > Index to Reports > Accounts > Transaction Journal. Filter for 'Deleted' or 'Reversed' transactions within your reconciliation period.

If you find something, you need to understand why it was deleted. Was it a genuine error that needed correcting, or was it accidentally removed? Accidental file deletions are a common human error threatening data integrity.

Preventing Mismatches Before They Happen

Finding and fixing discrepancies is necessary. Preventing them in the first place is better.

These aren't nice-to-have habits. They're non-negotiable if you want accurate financial reports without spending hours each month playing detective.

Set a Weekly Reconciliation Routine

Weekly reconciliation catches errors while they're fresh. You remember the transaction from three days ago. You don't remember it from three weeks ago.

Block the same time each week. Friday afternoon works well for most businesses. Fifteen minutes weekly beats three hours monthly of frustration.

The difference isn't just time. It's stress. When you reconcile weekly, discrepancies are small and easy to trace. When you reconcile monthly, they've compounded and you're trying to remember details from a month ago.

Create Rules for Recurring Transactions

MYOB's bank feed rules automatically categorise recurring transactions, which reduces manual entry errors.

Here's how: identify a recurring transaction in your bank feed, click 'Create Rule', set your matching criteria (amount, description, etc.), and assign it to the correct account.

Good candidates: monthly software subscriptions, rent, utilities, regular supplier payments. Anything that happens predictably.

This is exactly the kind of data validation process that organisations should implement to minimise errors.

Audit Your Bank Feed Matches Monthly

Even with rules in place, you need to check that transactions are being matched correctly.

Once a month, review how your bank transactions were matched to MYOB entries. Look for patterns of incorrect matching that might indicate a rule needs adjustment.

Spot-check 10-15 matched transactions. Make sure they went to the correct accounts. If you find consistent errors, fix the rule so it doesn't keep happening.

If you're finding this process overwhelming or time-consuming, working with specialists like Absolutebooksnbas can help you set up systems that work for your business without requiring constant manual oversight.

When Your Numbers Finally Match

There's a specific kind of relief that comes from seeing your MYOB balance match your bank statement exactly.

It's not just about the numbers being right. It's about knowing you can trust your reports. That when you make decisions based on your financial data, you're working with accurate information, not guesses.

Contrast that with the opening scenario: the panic of discovering a $2,400 discrepancy right before month-end, the stress of not knowing if your reports are reliable, the time wasted hunting for the problem.

Clean books give you clarity. They let you focus on running your business instead of fixing data problems.

The prevention habits outlined here aren't complicated. Weekly reconciliation, bank feed rules, monthly audits. Simple systems that save hours of frustration.

If you need expert help getting your MYOB reconciliation processes right, Absolutebooksnbas specialises in helping businesses implement reliable bookkeeping systems that prevent these problems before they start. Get in touch for a consultation.