Important Bookkeeping Reports You Must Know

The process of keeping accurate business records, also known as bookkeeping, is very important for a variety of reasons.  Not only are you able to track all of the business transactions that occur within a specific period of time, you will also be able to use this information to create useful bookkeeping reports to help further examine the health and profitability of your company.

To give you a better idea of what types of documents you can create from your business records, below is a list of some of the most common bookkeeping reports, and how they can benefit your company.

Banking Reports: These types of report can be created from basic banking sections of your records and can pinpoint specific check details, details of all deposits that have been made over a period of time, as well as any missing or returned checks.

Budgeting Reports: A budgeting report is basically a form of a profit and loss statement.  This can show how the business is doing on the whole, as well as how the projections for the quarter stack up when compared to the actual detail.

Company and Financial Reports: There are a number of reports that can be created from basic financial data that has been recorded on the books.  Here you can examine in depth balance sheet details, cash flow, statement of cash flow, vendor expenses, detailed vendor reports, income sorted by customer, income sorted by service or product, profit and loss by job, profit and loss year to date, profit and loss by class, and other profit and loss details that are broken down by specific criteria.

Customer and Receivables Reports: Basic customer and accounts receivable data can also yield a variety of customised reports.  These reports can include account receivable ageing detail, collections reports, customer balance details, outstanding invoices, unbilled costs by job, and customer transaction lists. Inventory Reports:  Inventory reports can help business owners to track inventory status by item number or by vendor, and also perform inventory valuation.

Custom Reports: In addition to the above mentioned reports, there are also a wide variety of custom bookkeeping reports that can be created as well.  These documents can be extremely beneficial to businesses and can include reports such as payroll details, employee earnings summaries, tax details, worker’s compensation summaries, accounts payable ageing detail, sales by representative details, sales by item number, and vendor balance detail and summaries.

Did you know we do bookkeeping in Melbourne too? Contact us today on 1300 2books

Our Reader Score
[Total: 1 Average: 5]

Comparing LEAP vs Actionstep- Xero Integration

Let’s face it- most lawyers aren’t really that interested in the way Actionstep and LEAP integrate with Xero. As long as their trust account is all taken care of, they are not really worried about how the information is transferred to their Practice Accounts- that’s for the bookkeeper to worry about!

That’s fine if the firm has a strong Legal Bookkeeper but if not then the Practice Manager or Principal should understand the integration to ensure they are producing accurate management and BAS reports.

The way both LEAP and Actionstep “talks” to Xero is quite different and both have their advantages and disadvantages as outlined below:

Nature of Integration

LEAP- You need to select your method of integration based on your GST registration of either cash or accrual. You can also integrate on a “Hybrid” basis which allows you to run management reports on an accrual basis while still lodging your BAS on a cash basis. Changing between the accounting basis is problematic and requires the engagement of LEAP Consultant.

The integration works using General Journals which creates a messy ledger which can make reconciliations difficult if it gets out of balance. The hybrid integration actually creates a separate GST code that does not get picked up on the BAS reports until the invoice is paid where it reverses the original transaction and re-posts the journal with the correct GST codes.

Actionstep- The invoices and payments for both sales and purchases are replicated in Xero so there is no need for journals. This creates a much cleaner integration and allows you to run cash or accrual management or BAS reports at any time.

Xero has a brilliant bank feed function, however it can sometimes be too clever for its own good. As the invoices have been exported from Actionstep to Xero, when Xero picks up a receipt for the same amount as an outstanding invoice it tries to match it automatically to the outstanding invoice in Xero. If this is matched in the Xero bank rec before it is entered in Actionstep it will not allow you to enter the receipt in Actionstep as it will think that invoice has already been paid. This can be difficult to identify for inexperienced Xero users.

Winner- Actionstep

Credit Notes

LEAP- Credit notes export to Xero as a journal. This works quite seamlessly although their is an ongoing issue with the GST coding on credit notes so the journal needs to be manually adjusted either prior to export or in Xero.

Actionstep- Credit notes in Actionstep are applied to invoices via a payment of $0 so that the credit note can be matched up to the correct invoice. Xero can’t handle a $0 payment so it creates credit note and a payment for the value of the credit note. The payment needs to be deleted via “remove & redo” and the credit note need to be applied against the invoice in Xero.

Winner- both problematic but the LEAP solution is probably easier to handle in Xero

Debtors and Creditors Reports

LEAP- all debtors and creditors reports need to be rune from LEAP as they are only sent ot Xero in journals

Actionstep- all debtors and creditors reports can be run from either Actionstep or Xero

Winner- Actionstep


Both LEAP and Actionstep work on a one-way integration, meaning that any changes to Debtors or Income in Xero will not flow back to the Practice Management system. This means that your Legal bookkeeper should have a high level of accounting knowledge to ensure the integrity of the 2 systems.

Overall Winner– you would have to say that Actionstep has the more comprehensive and versatile integration but you need to have a better understanding of Xero if things go pear-shaped.

Our Reader Score
[Total: 1 Average: 5]

Are BAS Agents Business Saviours?

Will Cowie from Inspire Education talks about the benefits of engaging a Registered BAS Agent.. A friend of mine got fined by the Australian Tax Office. He ran a small computer store in the suburbs servicing his local community, but his story applies equally to any small business owner. To save money, he used to do keep his own books and prepare his own Business Activity Statements (BAS). Unfortunately, while he was great with computers, bookkeeping wasn’t one of his strengths. He made errors, underreported his tax obligations and ended up with a fine on top of his outstanding tax obligations. It took years to pay off and added an extra layer of financial stress on top of the normal trials of small business ownership. After being hit with that fine, he hired a bookkeeper who was registered as a BAS agent. The agent took over nearly all the recording and reporting tasks for the business. It freed my friend up from hours work each week; work that he hated doing. That was time he could use to improve his business, bill more hours, or simply go home and enjoy his Friday evenings with his family. If you think hiring a bookkeeper and BAS agent is expensive, consider the alternatives. It just might be a great investment in your business and your peace of mind! What is a BAS Agent? A registered BAS agent is an individual, partnership business or company that can provide BAS-related services like BAS preparation and lodgement or advice about BAS laws. They must meet strict training, experience and professional standards set out by the Tax Practitioners Board. If a bookkeeper is providing BAS services for a fee or other reward, then they need to be registered as a BAS agent. “BAS agents” were created as part of the Tax Agent Services Act 2009 and were first introduced in 2010. Before that time, only Tax Agents were supposed to do BAS, but many bookkeepers started to offer the service anyway. The problem is they weren’t always qualified or experienced enough, leading to a lot of costly mistakes! Clients like you got burnt, the bookkeeper was likely sued and everyone lost out. What Does BAS Agent Registration Represent? Today, bookkeepers doing BAS must be suitably qualified and registered as a BAS Agent. They need to have:

  •  A recognised and approved qualification like the Certificate IV in Bookkeeping (or an equivalent or higher level bookkeeping/accounting course).
  • Completed at least 1,400 hours of relevant work experience in the last 3 years.
  • Completed approved courses in GST and BAS principles.
  • Passed a “fit and proper person” test.
  • Professional indemnity insurance that offers you, the client, financial protection.

BAS agents must also abide by a strict code of professional conduct and can lose their registration if they don’t. They also need to keep up with ongoing education and professional development, ensuring they keep their skills up to date. Ultimately, this means you can hire a BAS agent and be confident in their skill and ability to prepare your BAS correctly. What are the Benefits of Hiring a BAS Agent? BAS agents are trained, practiced professionals. As with anything in life, practice makes perfect. Your agent will almost certainly be able to prepare your statements faster than you could, and more accurately too. Their job is to know the laws relating to GST, PAYG and other taxes reported in BAS so they can get the maximum benefits for you too. If you haven’t been keeping up to date with your reporting or tax payments (and sometimes businesses do fall behind) hiring a BAS agent is an excellent move. They can help sort out your finances and it sends a strong message to the Australian Tax Office that you’re taking the problem seriously and will do better in future. It can be a big help if you’re negotiating with the ATO and paying off fines and outstanding debts. Another major benefit BAS agents offer is an extended lodgement period. Agents can have up to 28 extra days to prepare and lodge your BAS documents on your behalf. That means you have more time to collect your information and find cash to pay a tax bill. Finally, BAS agents almost always start out as bookkeepers and most continue to offer bookkeeping services too. They can help you set up quality financial recording and reporting systems in your business; or refine and make your current systems more efficient. Why Not Hire a BAS Agent Today? Rather than wait until it’s too late, hire a BAS-certified bookkeeper today. Once you’ve got bookkeeping systems in place, recording transactions and tracking GST will be much easier. Good data can actually help you keep more money in your pocket! You’ll know exactly what you owe and your BAS agent can use that data to maximise your BAS. You’ll be able to sleep easy at night knowing your BAS are taken care of, plus you’ll have more free time in your year to spend how you choose. William Cowie is a content production specialist for Inspire Education, one of Australia’s leading vocational education organisations. Inspire provides Bookkeeping, BAS, Health and Safety, and Training and Assessment courses.

Our Reader Score
[Total: 1 Average: 5]