Chapter 14

Checking Your Work

In This Chapter

Sweeping through the bank accounts with a stiff broom

Getting debtors and creditors spick and span

Ensuring your tax codes are as clean as a whistle

Mopping up control accounts

Digging for dirt

One of the services I offer as part of my consultancy business is a 12-step bookkeeping health check, where I go through a client’s set of accounts from top to bottom, identifying possible problems.

Clients sometimes wonder how I can sit down in front of a set of seemingly perfect accounts containing many thousands of transactions and, in a few minutes, uncover a whole list of mistakes. Contrary to popular opinion, I don’t have any psychic gifts or special powers, just a bag of tricks that I’ve honed over many years.

I’ve guarded these techniques carefully over the years, but in this chapter, I share the whole kit and caboodle with you. Best of all (and unlike other kinds of health checks that I’d rather not think about right now), no physical exercise, diets or grisly confessions are involved.

Starting with the Bank Accounts

The first three steps of my 12-step health check involve verifying bank balances. Not only do I check that every account is reconciled, but I also check for stale transactions and strange-looking dates.

Bank accounts are a great starting point when you’re checking accounts; if a bank account balance isn’t correct, you can be sure the accounts themselves aren’t correct.

Step 1: Checking that everything reconciles

Earlier in this tome, I devote an entire chapter (Chapter 10, to be precise) to the scintillating topic of bank reconciliations. Bank reconciliations form the guts of the whole accounting business, because until you’re sure that all bank accounts balance, you can’t rely on a single report.

Ask yourself the following:

• Is every business bank account reconciled, including savings accounts and credit cards?
• Is every loan account reconciled?
• Does every clearing account, such as Undeposited Funds, Electronic Clearing or Payroll Clearing, return to zero at the end of the period?

Is your answer yes to every question? Then well done, Step 1 of your health check is complete.

Xero refers to the process of reviewing and allocating transactions as reconciling your bank account. However, even if you have clicked off every transaction and the dashboard says your bank account is reconciled, this doesn’t mean that your work is complete. To be confident that your bank account really does reconcile (and because bank feeds aren’t 100 per cent accurate), you still have to double-check that the closing balance in Xero matches with the closing balance on your bank statement.

If you’re doing this health check at the end of a financial year, you may want to photocopy or scan the bank statement page that includes the balance as at the last day of the year (30 June in Australia, 31 March in New Zealand), and attach this to your bank reconciliation for that period, proving that each account is properly reconciled.

Step 2: Hunting for stale transactions

As I wrote this chapter for the first edition, the languorous summer holidays were drawing to a close. Before sitting down to write I thought I’d be a good mum and spring clean my son’s bedroom before term began. As soon as I fished Finbar’s school bag out from under his bed, I regretted my maternal zeal. Sure enough, still at the bottom of the bag from six weeks ago was an entire packed lunch, complete with a banana (what was I thinking?) and a ready-to-explode fermenting juice bottle.

Truth is, if you leave anything lying around for long enough, it begins to stink. And accounts are no exception. Step 2 of the bookkeeping health check involves hunting for trouble, making sure that no bank accounts show any unreconciled transactions more than a couple of months old.

Here’s how:

1. Go to your bank reconciliation reports and highlight all unreconciled transactions that are more than eight weeks old.

   Transactions that are more than eight weeks old and still haven’t cleared through the bank account are called stale transactions.

2. Investigate every stale transaction and figure out why it hasn’t cleared.

   Possible causes include

   • Duplicate entries — if you enter something twice, the duplicate shows as uncleared
   • A cheque that got lost in the post or a supplier who has a cheque from you but hasn’t yet gone to the bank
   • A mistake — maybe this transaction never occurred, or you allocated this transaction to the wrong bank account
   • An error with a bank feed — possibly a double-up with a date, or a transaction that came through twice
   • A customer payment received in cash, and the cash was never banked
   • An end-of-year adjustment entry to the bank made by your accountant

3. Fix the problem! Delete duplicate transactions, reverse stale cheques or contact suppliers for cheques not yet banked.

   All done? When you’re confident you have no stale transactions hiding in your accounts, and no stale toast hiding in the cracks of your sofa, Step 2 of your bank account health check is complete.

Step 3: Drilling down on dates

The third step of your bookkeeping health check is to track down any transactions with dates that have gone astray. This step is only relevant if you’re using accounting software, which sorts transactions automatically according to date.

Future-dated transactions

So the new (calendar) year starts and you stagger into work in a kind of haze (being at the beach would be so much more fun), and you start doing the books. Trouble is, the dates are an unholy mixture of the old year and the new, and before you know it (well, you don’t know it actually, because you’re in that delicious haze), you end up dating a transaction for the December not just gone, but the December that’s still 11 months away.

Future-dated transactions, especially if you date a transaction completely the wrong year, can be costly, because for every wrongly dated transaction, you potentially get a missed tax deduction.

If you’re lucky, your accounting software may have a future-dated transaction report (MYOB, QuickBooks Online and Reckon Accounts have this nifty feature, but not all other software does). If this report doesn’t exist in the software you’re using, your best bet is to generate a Profit & Loss report for the next 12 months, starting with the current date. This report should come up blank, with no income and no expenses. If not, chances are any figures on this report are caused by future-dated transactions.

Prepaid transactions (payment date before invoice date)

The other kind of dating error (that expression ‘dating error’ elicits a few quirky memories) that causes problems is if you get a customer or a supplier payment that’s dated earlier than the invoice or bill to which this payment belongs.

For example, imagine I record a customer payment dated 29 June for an invoice dated 2 July, and my financial year ends on 30 June. From an accounting perspective, a customer can’t pay for a sale that hasn’t happened yet. The customer payment affects my debtors balance at year end, but the income doesn’t hit the accounts until the following financial year. Ugly.

If you’re lucky, your accounting software may have a prepaid transaction report. If this report doesn’t exist in the software you’re using, the easiest way to spot prepaid transactions is to check your debtors and creditors control accounts, a process I cover in Step 8 of this health check.

Spring Cleaning Your Debts

Do you use your accounting software or bookkeeping system to keep track of how much customers owe you, or what you owe to suppliers? If so, it pays to make sure that the information about your debts is completely spot-on.

The report showing how much customers owe is usually called an Aged Receivables report or an Aged Debtors report, and the report showing how much you owe to suppliers is usually called an Aged Payables report or an Aged Creditors report. The terminology doesn’t matter, so long as the report itself is right.

Step 4: Getting debtors spick and span

Step 4 of your bookkeeping health check involves getting a debtor listing that’s 100 per cent perfect. In other words, if a customer name appears on your Aged Receivables report, you — or anyone else for that matter — want to be completely sure that this customer owes exactly that amount.

Take action now:

• Tidy up amounts that you know are wrong: If a customer shows in your Aged Receivables report but you know they don’t really owe money, fix the account now. (This problem is often caused by customers paying in cash and then the owner pocketing the cash, sweet cash, without banking a single cent. In this situation, the solution is to credit the customer’s account, allocating this credit to Owner’s Drawings.)
• Write off piddly amounts: Get rid of any pesky accounts where only a few cents are owing. You’re never going to phone a customer and chase ’em for five cents, are you? (Refer to Chapter 8 for how to write off bad debts, but for small balances, simply create a credit note, and code this note back to sales.)
• Check the dates of all customer deposits: Customer deposits normally show as a liability in an account called something like Customer Deposits Held. Any customer deposits that are more than a few weeks old usually indicate that a deposit has been received and the job completed, but nobody has remembered to convert the sales order to a final invoice.
• Investigate any old amounts over 90 days: If accounts are genuinely overdue, chase the money now (for money-chasing tips, skip to Chapter 20). Or, if an account shows as overdue because there’s a dispute or possibly a bookkeeping error, spend the time trying to resolve the problem.

Step 5: Sweeping through the creditors

Just like the clutter that piles up on the kitchen bench, you quickly get clutter building up in your Aged Payables report. By clutter, I mean amounts that show as owing but which you know are really odd unallocated credits, duplicate bills and other similar rubbish.

Step 5 of your bookkeeping health check means showing no mercy. In Figure 14-1, I show an Aged Payables report that’s looking a bit sad, and I’ve circled all the transactions that I reckon need a bit of attention.

Keep in mind the following:

• Get rid of bills that you know you don’t owe: If a bill shows as owing in your Aged Payables report but you’re sure you’ve paid the bill, check that you haven’t entered the bill twice (and, if so, delete or reverse the duplicate). Or, if you recorded this bill payment in the cash journal, rather than matching the payment against the bill, either reverse the cash journal payment, or reverse the bill.
• Write off small amounts: If you have old amounts where you only owe a few cents and the supplier isn’t chasing you for the money, raise a credit to write off the balance, allocating this credit to the same account used originally.
• Enter credit notes: If you didn’t pay a bill because there was a dispute, and the supplier has agreed you don’t have to pay, record a credit note to bring the account to zero.
• Investigate all minus amounts: Sure, you may have a credit outstanding with a supplier, but any minus amounts in your Aged Payables report warrant investigation.
• Deal with cash payments correctly: If a bill shows as owing but was actually paid for in cash by the owner, raise a credit for the bill, allocating the credit to Owner’s Drawings or to Directors’/Shareholders’ Loan.
• Look into amounts over 90 days old: Investigate every single bill that’s more than 90 days outstanding. Unless the business you do the books for is a woeful payer, any bill that’s more than 90 days old is likely to be an error.

All done? Now why don’t you make your way over to my house and deal with all my clutter …

Putting GST under the Griller

Steps 6 and 7 of your bookkeeping health check involve checking GST. Step 6 focuses on whether transactions have been coded correctly and is usually a fairly straightforward process, particularly if you already have your head around what gets taxed, and what doesn’t. (For more info about this topic, refer to Chapter 6.)

The seventh step of the health check from hell is probably the most technical of all the checks in this chapter, and involves reconciling the GST liability account or accounts in the Balance Sheet. If you find yourself quailing when you arrive at this topic, you may prefer to ask the company accountant to give you a hand.

Step 6: Hunting for coding mistakes

The sixth step of the bookkeeping health check involves verifying whether you’ve shown the correct amount of GST on every transaction. If you use accounting software, check that all transactions have the correct tax code; if you do books using a spreadsheet, check that all transactions show the correct amount of tax in the GST column.

In MYOB, QuickBooks Online and Reckon Accounts, I find the quickest way to spot tax code errors is to generate a Tax/GST Code Exceptions report (this report forms part of the Company Data Auditor in MYOB, and the Data Auditor in Reckon Accounts); in Xero, I make my way to the General Ledger Exceptions report.

Just because a transaction appears on an exceptions report doesn’t necessarily mean you’ve made a mistake. For example, Figure 14-2 shows three possible reasons transactions appear as tax exceptions:

• On the first line, the transaction for electricity is genuinely an error —the tax code should be GST, but the bookkeeper has entered FRE as the code.
• On the second line, the transaction is correct, but the default code for Stationery Expense account is wrong. The bookkeeper needs to edit the default tax code settings for this account.
• On the third line, both the transaction and the default code are correct. The software was purchased from overseas, and so FRE really is the correct tax code. However, usually transactions allocated to Software Expense have GST on them, so the default tax code is also correct.

If you use a spreadsheet, the easiest way to check your GST amounts is to look for inconsistencies. For example, take a month’s transactions, total all the expenses you know attract GST (such as advertising, computer gear and telephone), and then multiply this total by 10 per cent (in Australia) or 15 per cent (in New Zealand) to arrive at how much the total GST should be for that month. Check this figure against the actual GST total.

When you’re sure you have the amount of GST correct on every transaction, you can progress to balancing your GST accounts. Are you having an unbelievable amount of fun? I hope so.

Step 7: Balancing GST liability accounts

If you’re working with accounting software, making sure that the balance of your GST liability accounts is correct is a vital part of your bookkeeping health check. On the other hand, if you do books using a spreadsheet, and you don’t generate your own Balance Sheet reports, you can safely skip this step.

So the theory behind this health check is this: Every time you record a transaction that includes GST, this transaction impacts on your GST liability account(s). When you pay GST, this payment makes the balance of your GST liability account or accounts go down. In other words, the balance of your GST liability account or accounts is a running balance of how much you owe.

The mechanics of your health check depend on whether you report for GST on an accrual or a cash basis.

If you report for GST on an accrual basis, here’s what to do:

1. Generate a Balance Sheet for the last day of the reporting period on your most recent Business Activity Statement or GST return.

   For example, if your most recent Business Activity Statement or GST return was for the month of June, generate a Balance Sheet dated 30 June.

2. On your Balance Sheet, look at the balance of your GST Collected and GST Paid accounts, or your GST Payable account.

   You may have two liability accounts — one called GST Collected and another called GST Paid — or you may have a single GST liability account called GST Payable.

3. Look up the amounts you declared for GST Collected and GST Paid in your most recent Business Activity Statement or GST return.

   In the land of The Wallabies, you’re looking at boxes 1A and 1B on your activity statement. In the land of the All Blacks, you’re looking at boxes 11 and 15 on your GST return.

4. Compare the figures from Step 2 against the figures from Step 3. Guess what? They should match.

   If you only have one combined liability account for GST, you compare this balance against the net balance of GST Collected less GST Paid.

   If the two figures don’t match and the difference is more than $100 or so, take further action. I suggest you go right back to the beginning of the financial year, and do this health check for each GST period — you should be able to pinpoint where the rot set in. If the problem relates back to before the beginning of the financial year, your best approach is usually to talk to the company accountant.

If you report for GST on a cash basis, things take a much trickier turn, because you have to allow for the GST that you haven’t paid yet (because you haven’t received payments from customers for outstanding invoices or you haven’t paid suppliers for outstanding accounts). I’m a little hesitant sharing this procedure with you, because the whole deal is unashamedly tricky, but if you can master reconciling GST on a cash basis, you know that you’re truly ahead of the pack.

Here’s what to do:

1. Look up the amounts you declared for GST Collected and GST Paid in your most recent Business Activity Statement or GST return.

   In Australia, you’re looking at boxes 1A and 1B on your activity statement. In the land of the long white cloud, you’re looking at boxes 11 and 15 on your GST return. Of course, if you’re doing this reconciliation before lodging your Business Activity Statement or GST return — which is, of course, always a good idea — you’re probably looking at the draft report generated by your accounting software.

2. Generate an Aged Receivables report and an Aged Payables report, and calculate how much GST is included in the totals of each of these reports.

   For example, if I’m owed $11,000 and I charge GST at a rate of 10 per cent and I charge GST on all my sales, then I can calculate that my receivables include $1,000 in GST.

   If you’re using MYOB, two neat reports that help pave the way are the Receivables with Tax report (called the Receivables Summary with GST in New Zealand) and the Payables with Tax report (called the Payables Summary with GST in New Zealand).

3. Add the amount of tax on receivables (see Step 2) to GST Collected (see Step 1), and add the amount of tax on payables (see Step 2) to GST Paid (see Step 1).

   Or, if you only have one combined liability account for GST, add the net tax from receivables and payables to the net balance of GST Collected less GST Paid.

   Figures 14-3 and 14-4 show how this whole drama works. Figure 14-3 shows how to reconcile GST if you have two separate GST liability accounts (probably MYOB is the only accounting software where this applies); Figure 14-4 shows how to reconcile GST if you have a combined GST liability account (most other accounting packages).

4. Generate a Balance Sheet for the same period, and look at the balance of your GST Collected and GST Paid accounts, or your GST Payable account.

   For example, if your most recent Business Activity Statement or GST return was for the month of June, generate a Balance Sheet dated 30 June.

5. Compare the figures from Step 4 against the figures from Step 3. If the stars are in your favour, these figures should match.

   If the two figures don’t match and the difference is more than $100 or so, take further action. I suggest you go right back to the beginning of the financial year, and do this health check for each GST period. This way you can hopefully see where the problem began. If the problem relates back to before the beginning of the financial year, your best approach is usually to talk to the company accountant.

Understanding Control Accounts

In a perfect world, if you look at your Aged Receivables report and the total amount owing from customers is $33,000, then the corresponding balance of Accounts Receivable in your Balance Sheet should also be $33,000. (Note: Some accountants use the term Trade Debtors rather than Accounts Receivable.) This is because your Aged Receivables report shows the detail of how much customers owe you, and your Accounts Receivable account tracks the total amount that customers owe you.

In accountant-speak, your Accounts Receivable account is called a control account. A control account is a general ledger account where the balance reflects the total of balances in other related accounts. In this example, Accounts Receivable is the general ledger control account, and the individual customer balances are the related accounts. Accounts Payable is another common control account, where the individual supplier balances are the related accounts.

In this section, I explain how to play the matching game of four key control accounts:

• Accounts Receivable: I match the total of individual customer balances against the balance of my Accounts Receivable account. (See the following section for details.)
• Accounts Payable: I match the total of individual supplier balances against the balance of my Accounts Payable account. (See the following section for details.)
• Inventory: I match the total value of individual stock item balances against the balance of my Inventory account. (See ‘Step 9: Giving inventory the once over’ for details.)
• Payroll Liabilities: I match the individual amounts owing in wages tax and super for each employee against the total outstanding in the corresponding payroll liability accounts. (See ‘Step 10: Priming the payroll’ for details.)

Step 8: Balancing debtors and creditors

Step 8 of your bookkeeping health check involves checking that your debtor and creditor control accounts balance. Here’s how:

1. Generate an Aged Receivables or Aged Payables report dated the last day of the month just gone.

   The name of this report varies, depending on what software you use. For example, in MYOB, you’re looking for the Receivables or Payables Reconciliation Summary report; in QuickBooks Online and Reckon Accounts, the A/R or A/P Ageing Summary report is the baby you’re after.

2. Generate a Balance Sheet for the last day of the month just gone, and circle the balance of Accounts Receivable and Accounts Payable.

   These accounts are also sometimes called Trade Debtors or Trade Creditors.

3. Compare the grand total of the report from Step 1 with the balance of your control account in Step 2.

   In other words, compare the grand total of your Aged Receivables report against the balance of Accounts Receivable in the Balance Sheet, and compare the grand total of your Aged Payables report against the balance of Accounts Payable in the Balance Sheet.

   In Figure 14-5, you can see how the Reconciliation Summary report in MYOB does this comparison for you.

4. If the two balances are the same, you can sleep easy tonight.

And, I can almost hear you ask breathlessly, what if the two balances aren’t the same? Then things get a little tougher:

1. If the two balances differ, start at the beginning of the financial year and move forward month by month, generating the two reports for the end of each month. After you find the month in which the difference arose, see whether you can pinpoint the exact day when it happened.

   You’re working on a process of elimination here. After you narrow down an out-of-balance amount to within a certain month, repeat the process for the days of that month (say, the 7th, 14th and so on), working towards identifying the first day that this out-of-balance amount appeared.

2. Look at the transactions in the corresponding general ledger account for that date. The offending transaction will probably leap out at you.

   For example, if your Accounts Receivable control account went out of balance by $140 on 28 February, look for a transaction for that amount on that date in this account.

3. Fix the transaction.

   Exactly how you fix this transaction depends on the cause of the problem — refer to the sidebar ‘A rotten potato spoils the barrel’ for more details. Ask the company accountant for advice if you’re still not sure.

4. Move forward through the months again, checking that no other transactions are incorrect.

   Remember, the aim of the game is to get the grand total of individual balances in the Aged Receivables or Aged Payables report to match the total of Accounts Receivable or Accounts Payable in the Balance Sheet. Don’t rest until you succeed!

Step 9: Giving inventory the once over

Sometimes inventory can be the very messiest part of the whole bookkeeping game. I talk about inventory transactions in Chapter 12, but in this chapter, I focus on how to make sure that your inventory is clean as a whistle.

Checking your inventory account

First things first: Check that the total value of all the individual stock items matches up with the value of the inventory account in your Balance Sheet, as follows:

1. Generate an inventory valuation report dated the last day of the month just gone.

   The name of this report varies, depending on what software you use, but what you’re looking for is a report that shows each item, the quantity of that item, the item cost and the total value. (For more detail about the different ways of costing inventory, skip back to Chapter 12.)

2. Scan the report for weird stuff.

   Open your eyes wide and you usually spot all kinds of sinister stuff. Look out for items with negative quantities (unless you’re operating on some metaphysical plane, stock existing in the negative usually indicates a problem). Also, scan the report for costs that defy common sense, such as a bunch of spinach having a cost value of $300, or a new washing machine having a cost value of two bucks.

3. Generate a Balance Sheet for the last day of the month just gone, and circle the balance of Stock on Hand.

   This account is also sometimes simply called Inventory.

4. Compare the grand total of the report from Step 1 with the balance of your control account in Step 3.

   In other words, compare the grand total of your inventory valuation report against the balance of Stock on Hand in the Balance Sheet.

5. If the two balances are the same, congratulations. If the two balances differ, proceed to my troubleshooting tactics.

   No need to tremble in your books. Read on, and all shall be revealed …

Troubleshooting your inventory account

Okay, so the total value of individual stock items isn’t matching up with the value of your inventory account. Time to pull on some of the more deadly tactics from my bag of tricks:

1. If the two balances differ, start at the beginning of the financial year and move forward month by month, generating the two reports for the end of each month. After you find the month in which the difference arose, see whether you can pinpoint the exact day when it happened.

   You’re working on a process of elimination here. After you narrow down an out-of-balance amount to within a certain month, repeat the process for the days of that month (say, the 7th, 14th and so on), working towards identifying the first day that this out-of-balance amount appeared.

2. Look at the transactions in your inventory account for that date. The offending transaction will probably leap out at you.

   Transactions that cause trouble are usually transactions that have been allocated directly to your Inventory asset account. Look for an inventory adjustment, or a cheque, supplier bill or general journal coded to the inventory account. If the transaction is an item purchase, double-check what accounts this item links to.

3. Fix the transaction.

   Exactly how you fix this transaction depends on the cause of the problem. If you’re not sure how to reallocate a transaction, ask the company accountant for advice or allocate the transaction to a suspense account.

4. Move forward through the months again, checking that no other incorrect transactions exist.

   The aim of the game is to get the total cost of individual stock items in your inventory valuation report to match the total of Stock on Hand in the Balance Sheet. Don’t rest until you succeed!

Step 10: Priming the payroll

Up to Step 10 in your bookkeeping health check? You’re a champion. Maybe now is the time to put your feet up, pour yourself a mellow glass of red and have a snooze. Oops, maybe that’s just what I feel like doing. No, keep going. What you need to do next is the following:

• Check that your PAYG Withholding Tax Payable (Australia) or PAYE Tax Payable (New Zealand) account reconciles. For the fine details, refer to Chapter 11.
• Check that your Superannuation Payable (Australia) or KiwiSaver Payable (New Zealand) account reconciles. Again, for the lowdown, refer to Chapter 11.

Doing a Mini-Audit

Auditing a set of books is more of a mindset, rather than a skill. I suggest you get into the mood by imagining that you’re actually an auditor. Ladies: Tie back your hair, remove any jewellery and strip your face of make-up. Gentlemen: You can probably just get away with not brushing your teeth.

Change into some tight black clothes (synthetic fibres preferred), and don your most severe expression. Lovely. You look like a real auditor now.

Step 11: Scanning transaction reports

Over the years, I’ve developed a sniffer-dog instinct for trouble. I can go through a set of books, scanning pages of transactions at a time, and hit on mistakes the same way that the beagle found my chocolate cookies at Sydney airport the other week.

The eleventh step of your health check involves scanning every single account for errors. If I’m working with accounting software, I usually display a General Ledger detail report, or something similar, and scroll down through the report on screen. A General Ledger report typically lists transactions in date order, sorted by account name.

I explain the tricks of the trade so that you can spot errors like a pro:

• Look for debits or credits appearing in the wrong column: Income always appears in the credit column in transaction reports and, if you see an amount in the debit column, chances are this is a mistake. Similarly, if you see an amount appearing in the credit column for an expense account, this amount is also likely to be a mistake.
• Count the number of transactions for regular payments such as leases or rent: For example, if you’re checking a year’s work in one hit and you know that rent gets paid monthly, you should have 12 rent transactions. If you see more or less, go looking for blood.
• Drill down on inconsistent amounts: Expense accounts tend to have similar amounts in each one. Maybe bank charges are normally less than $20, but electricity expense is usually over at least a couple of hundred bucks a time. So if you see an amount in an expense account that’s significantly higher or lower than the other amounts around it, drill down to see what’s cooking.
• Keep human nature in mind: Keep your eyes open for stuff that’s obviously personal but has been allocated to a business account. Likely suspects are travel and accommodation (the usual spot to allocate private meals and holidays); staff training (also known as private school fees); security expenses (dog food for dear Fido) and home office expenses (you name it, I’ve seen everything allocated to this account, from contraception to whisky).
• Read the names of who received payments: Sometimes you can pick up account misallocations just by looking at the payee’s name. For example, if you’re in New Zealand and see a payment made to Telecom sitting in the Electricity Expense account, chances are you’ve spotted a mistake.
• Double-check anything to do with the buying or selling of new assets, or the taking out of loans: For more on these tricky kinds of transactions, head back to Chapter 13.

Xero has a great little report designed purely to spot errors. Go to your reports menu, ask for a General Ledger report, then click the General Ledger Exceptions tab. This report displays all transactions that are a debit when you usually expect a credit (or vice versa), any transactions with odd tax codes, or any transactions with unusually high or low values when compared to other transactions in the same account. Brilliant.

Step 12: Analysing summary results

I talk more about understanding Profit & Loss reports in Chapter 15, but for now, I’m going to focus on looking at a Profit & Loss report with a view to spotting problems.

Here’s what to look out for:

• Compare this year’s results against last year’s results. If something is notably different between the two years, investigate why.
• Check the gross profit margin is relatively constant between this year and last year’s, and from month to month. (I explain more about gross margins in Chapter 15.)
• Look for negative balances. If an income or expense account shows up as a minus, investigate why.
• Look at the bottom line. Are you rolling in money? If not, why not?