And How to Fix Them Before They Cost You
Most businesses start their QuickBooks Online journey the same way: Someone signs up, connects the bank feed, adds a few accounts and starts capturing transactions. It feels quick and sensible, and for the first few months it seems to work perfectly well.
The trouble is that a QuickBooks setup is a bit like the foundations of a building. Nobody admires them, and nobody thinks about them once the walls are up. But everything you build on top, from financial reporting and VAT returns to payroll and cash flow planning, depends on them. A shaky foundation doesn’t announce itself. It shows up two years later as a profit and loss report you don’t quite believe, a VAT return that takes a week to piece together, or a pricing decision based on the wrong numbers.
As a QuickBooks Online specialist, we see this often, and it is not a criticism of businesses that set things up themselves. Most do it because they are practical and want to get moving. The point is that the way a system is set up in the first few weeks shapes the quality of your financial data for years afterwards. The good news is that almost every DIY setup can be corrected without starting from scratch.
Below are the five problems we see most often, what they really cost, and how to put things right.
1.The Chart of Accounts Doesn’t Match How You Manage the Business
QuickBooks Online will happily let you create an account in any way you like, but it doesn’t know how your business earns and spends money. Take a small manufacturer with three product lines. If all sales go into one income account and all materials into one cost account, overall profit may look healthy while one product quietly loses money. Nobody finds out until someone rebuilds the picture by hand.
This is also why reporting by branch, department or project so often disappoints. QuickBooks Online can do it well, but only if the structure was built in from the start and is used consistently by everyone capturing transactions.
2.Opening Balances Were Never Properly Checked
When a business moves from spreadsheets or another system, the starting figures for debtors, creditors, stock and the bank need to be right, or every report that follows carries the error forward. It is one of the hardest problems to spot, because the day-to-day numbers look fine.
3.VAT Is Set Up Inconsistently
The wrong VAT code on a supplier, zero-rated and exempt items treated the same way, or imports captured inconsistently can all quietly distort your VAT returns. For South African businesses this matters, because SARS expects the figures to be supportable, and unpicking months of incorrect coding is far more expensive than getting it right at the start.
Reviewing a few past VAT returns against the underlying transactions often reveals patterns that repeat every period. Getting VAT right isn’t only about compliance, it is about making sure the profit on your reports is the profit you actually have.
4.The Bank Feed Is Connected but Not Controlled
Without clear bank rules, transactions are matched inconsistently, payments are recorded twice, and transfers between accounts show up as income and expenses. Reconciliation becomes a monthly investigation instead of a quick final check, and management reports arrive late.
5.Payroll and Stock Aren’t Set Up to Feed the System Properly
Unlike in some other countries, QuickBooks Online in South Africa does not have payroll built in. Payroll is run in a dedicated system, and we typically use PaySpace or Vanilla Payroll, depending on the client’s needs. The results are then brought into QuickBooks Online as a journal. That journal is only as good as the accounts behind it. When payroll accounts are not set up correctly, reporting suffers.
A very common mistake, especially among small and medium businesses, is to capture only the net salary from the bank feed. The profit and loss then shows what was paid into employees’ bank accounts, and leaves out the full cost to company: PAYE, UIF, SDL and other deductions and employer contributions. Payroll costs look lower than they really are, and profit looks better than it is.
Stock causes a similar problem when it is tracked on a spreadsheet that never quite agrees with the books. In both cases, every manual hand-off is another chance for the numbers to drift apart.
What This Really Costs a Business
The direct costs are easy to see: extra hours at month-end, a bookkeeper who spends more time correcting than capturing, and the fees for fixing a year of messy data at year-end. The indirect costs matter far more.
When owners and managers can’t trust their reports, they stop using them. Pricing is set on instinct. Hiring is delayed or rushed because nobody is sure what the business can afford. Stock is ordered on what feels right rather than what has actually been selling. In a retail or hospitality business that can mean cash tied up in slow-moving stock; in a professional services firm it can mean taking on work that looks profitable but isn’t.
That is the real expense of a weak setup. It isn’t the hours spent fixing it, but the decisions made with less clarity than they could have had. Good financial data leads to better pricing, hiring, stock and cash flow decisions, and the reverse is just as true.
How to Fix a DIY Setup Without Starting Again
Almost no business needs to abandon QuickBooks Online and begin again. Most problems can be corrected in place, usually faster than owners expect, by working through the file in a sensible order:
- Decide which questions your numbers must answer, such as profit by branch, product or customer, cash expected over the next few months, and your VAT position at any time.
- Review the foundations: chart of accounts, opening balances, VAT settings, bank rules and the accounts your payroll journal posts to.
- Automate the routine work with bank rules and tools like Dext, so supplier invoices and receipts flow straight into QuickBooks Online instead of being typed in.
- Agree simple, documented coding rules so the file stays consistent as the team grows.
This is also where working with a QuickBooks Online partner pays off. As QBO business partners, we have specialist tools that can reallocate transactions and correct inaccuracies in bulk, rather than fixing them one entry at a time. That makes a clean-up considerably faster and more cost-effective than most owners expect.
The result is a system where the repetitive admin happens in the background, and people spend their time reviewing exceptions and understanding what the numbers mean.
Setting It Up Once, Properly
If you are about to start with QuickBooks Online, or have recently begun, the best time to get expert input is now. A proper QuickBooks setup doesn’t need to be slow or expensive. It means a short conversation about how your business works, a structure built around it, and processes for payroll, VAT returns and bookkeeping that all draw from the same reliable data.
For businesses that already have a file in place, the sensible starting point is a short review. It identifies what is working, what isn’t, and a practical order for fixing the gaps, without disrupting how your team currently works.
Common Questions We Hear From Clients
Q: “We set up QuickBooks ourselves and it seems fine. Do we need a review?”
A: If your reports are trusted, your VAT returns reconcile and reconciliation is quick, you may be in good shape. If any of those feel harder than they should, a review will usually find the cause quickly, and the fix is rarely as large as owners fear.
Q: “Will we have to start again in a new file?”
A: Almost never. Most corrections, such as tidying accounts, fixing VAT codes and adding tracking, are made inside your existing QuickBooks Online file, so your history is kept.
Q: “Does our bookkeeper need to change how they work?”
A: Only slightly. A better structure and clearer coding rules usually make their work faster, and we walk the team through any changes directly.
A DIY QuickBooks setup is rarely a mistake in the moment, but its effects build quietly. The businesses that get the most from QuickBooks Online are the ones whose system matches how they actually run, so that pricing, hiring, stock and cash flow decisions are made on numbers they can trust.
Your financial systems matter. Better systems create better decisions, and automation takes the repetitive admin away so you can focus on the business.
If you’re unsure whether your current QuickBooks Online setup is giving you the visibility you need, allow us to step in and turn your financial data into meaningful business insight. Reach out to book your consultation.