Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 38 Next »


 

 

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?

AccountRight has hundreds of reports that help you analyse your business. If you're not sure where to start, take a look at some reports you'll find useful to review frequently.

Review your performance

Income and expenses

The Profit & Loss (P&L) statement is a standard financial report that tracks income and expenses, not cash in and out. Income is what you earn over the period, which isn't necessarily what you've been paid for. The same applies to expenses. You might have incurred the expenses, but not necessarily paid for them yet.

You'll find the Profit & Loss reports in the Accounts section of the Index to Reports.

Example: Profit and Loss:
Example: Profit and Loss [Multi-Period]:
 

 


 

Budget analysis

If you've set up a budget in AccountRight, you'll want to review how you've performed against it. AccountRight includes several budgeting reports.

Reports labelled [Multi Period Budget] allow you to review months side by side.

You'll find the budgeting reports in the Accounts section of the Index to Reports.

Example: Profit and Loss [Budget Analysis]:

Learn about budgets


Job results

You can see all transactions that have been assigned to a job using the Job Transactions report.

If you want to analyse the profitability of a job, try the Job Profit & Loss Statement report, and you can compare how much the job is costing against the job budget, with the Jobs [Budget Analysis] report. 

(Not Basics) To find out if you have any outstanding unreimbursed expenses for a job, use the Customer Reimbursable Expenses report.

You'll find the jobs reports in the Accounts section of the Index to Reports.

Example: Job Transactions:

Learn about jobs

Audit your data

Find a transaction using reports

Several reports can help you find a transaction.

For example, if you know the account associated with the transaction you are looking for, you can use the Account Transactions report. If you know the customer or supplier name, use the Card Transactions report.

You can take a look at a transaction by clicking its details in the report.

Here are some other reports you can use:

  • Job Transactions [Accrual] report: See all transactions recorded for a job. You'll find this report in the Accounts tab in the Index to Reports window.
  • Invoice Transactions [Accrual] report: See all transactions that relate to an invoice, including payments and credits. You'll find this report in the Sales tab in the Index to Reports window.
  • Bill Transactions [Accrual] report (Not Basics): See all transactions that relate to a bill, including payments and debits. You'll find this report in the Purchases tab in the Index to Reports window.
  • Payroll Category Transactions report (Plus and Premier, Australia only): See all pays recorded for a payroll category. You'll find this report in the Payroll tab in the Index to Reports window.

Example: Card Transactions:

See also Finding a transaction.


Review using a spreadsheet

While you can export any report to Microsoft Excel, there are a few reports that have been specifically designed for exporting to a spreadsheet. Look for reports that have [Multi-Period] in the name, like the following:

  • Balance Sheet [Multi-Period] report: See what your balance sheet looked like over several months.
  • Balance Sheet [Multi-Period Budget] report: Compare your balance sheet to the budgeted figures for several months.
  • Profit & Loss Statement [Multi-Period] report: See how you profitable you were over several months.
  • Profit & Loss [Multi-Period Budget] report: Compare your budgeted profit figures to the actuals, over several months.
  • Analyse Sales [Activity Spreadsheet] report (Plus, Premier): See the value of timebilling activities invoiced over several months.
  • Analyse Sales [Customer Multi-Period] report: See the value of sales recorded for your customers over several months.

Example: Analyse Sales [Customer Multi-Period]:

See also Exporting reports.

Analyse sales and calculate commission

Customer sales: who, what, and how much

There are many sales reports you can use. Try a few to see which suit you best.

Here are some we recommend:

  • Sales [Customer Summary] report: See total sales listed by customer
  • Sales [Customer Detail] report: See more detailed information about sales made, including items you sold from your Items List.
  • Analyse Sales [Customer - FY Comparison] and Analyse Sales [Customer Multi-Period] reports: Look for customer sales trends over a period of time.
  • Analyse Sales [Item] or Analyse Sales [Item - FY Comparison] reports (Not Basics): Analyse item sales, and compare sales to last financial year.
  • Analyse Sales [Activity] or Analyse Sales [Activity - FY Comparison] reports (Plus, Premier): Analyse time billing activity, and compare activity to last financial year.
  • Analyse Sales [Salesperson] or Analyse Sales [Salesperson - FY Comparison] reports (Not Basics): Analyse sales made by each salesperson.

Example: Analyse Sales [Customer FY Comparison]:

See also Reviewing your sales information and Sales reports.


Collecting money: who, how much, and how long

To help you keep on top of your debtors, use these reports:

  • Aged Receivables [Summary] report: See who owes you money (and for how long) 
  • Aged Receivables [Detail] report: See each sale amount owing to you with your customer contact details, so you can chase them up.
  • Customer Payments [Closed Invoices] report: Review how long it takes your customers to pay you. 
  • Invoice Transactions report: See the history of each invoice, including payments and credits.

Example: Aged Receivables [Summary]:

See also Receivables, payables or inventory out of balance.


Calculating commissions

Not available in AccountRight Basics

If you use complex commission plans for your salespeople, you may want to export these reports to Microsoft Excel:

  • Sales [Salesperson Summary] report: Use this report if you calculate commissions based on when the sale was made.
  • Customer Payments [Salesperson] report: Use this report if you pay commissions on a cash-received basis.
  • Sales [Salesperson Detail] report: This report shows you a break down of the items sold by your salespeople during the period.

Example: Sales [Salesperson Summary]:

See also Exporting reports.

Purchases and suppliers

Owing money: who, how much and how long

Not available in AccountRight Basics

To find out how much:

  • you owe a supplier, print the Aged Payables [Summary] report
  • you bought from a supplier, print the Purchases [Supplier Summary] report
  • you paid to a supplier, print the Supplier Payment History report.

To review the payment history of a purchase, print the Bill Transactions report.

Example: Supplier Payment History:

See also Reviewing your purchases information.

Inventory

Item sales: what is selling and who is buying

To find out:

  • how many of a particular item you sold, print the Sales [Item Summary] report or the Sales [Item Detail] report
  • which items you sold to a particular customer, print the Sales [Customer Detail] report
  • who bought a particular item, print the Sales [Item Detail] report.

Example: Sales [Item Detail]:

 


 

Items: What you have, what is promised, what is on order

Not available in AccountRight Basics

  • To see what’s on hand, what’s on order from suppliers, and what’s been promised to customers, print the Analyse Inventory [Summary] report.
  • To view orders and invoices for a single item, print the Analyse Inventory Detail] report.

Example: Analyse Inventory [Summary]:

See also See what's on your To Do list.


Counting, valuing, and analysing your inventory

Not available in AccountRight Basics

Relevant inventory reports include:

  • Inventory Count Sheet: Use this report to help you do a manual stocktake.
  • Inventory Value Reconciliation report: Use this report to check that the inventory asset account reconciles with the stock on hand values reported in the Items List.
  • Items Register Detail report: Get a detailed listing of transactions that have affected your stock.
  • Price Analysis report: See the profit margins and markups for your items.

Example: Price Analysis:

See also Recording stocktakes and Setting item prices.

End of period

Daily reports

Not available in AccountRight Basics

Here are some reports you might want to review at the end of each day:

  • To Do List - Expiring Discounts report: Use this Purchases report to see which discounts offered by your suppliers are expiring soon (based on your suppliers' credit terms).
  • To Do List - Orders To Be Shipped: Use this Sales report to see which orders need to be fulfilled next.
  • To Do List - Stock Alert: Use this Inventory report to see which items have reached their reorder point.

Example: To Do List - Stock Alert:

See also See what's on your To Do list.


Weekly reports

To review your week's activity, use these reports at the end of each week:

  • Aged Receivables [Detail] report: See which customers owe you money, and whose payments are overdue.
  • Aged Payables [Detail] report (Not Basics): See who you owe money to, and work out who needs to be paid next.
  • Bank Register report: Review the deposits and withdrawals made for your bank accounts.

Example: Bank Register:


Monthly reports

You can use these reports each month to see how you went, and what's coming up:

  • To Do List - Recurring Transactions report
  • Profit & Loss Statement
  • Balance Sheet report
  • Receivables Reconciliation [Detail] report
  • Payables Reconciliation [Detail] report (Not Basics)
  • Bank Register report

To help you analyse the performance of your business, you can print:

  • Profit & Loss Statement
  • Profit & Loss [Last Year Analysis] report

If you use the inventory module (Not Basics), you can also print:

  • To Do List - Orders to be Shipped and To Do List - Orders to be Received reports
  • Analyse Inventory Summary report

Quarterly reports

If you prepare summary reports quarterly instead of monthly, the following reports will help provide an overview of your business’ financial health for the quarter. To help ensure the reports are accurate, enter all relevant financial transactions first, such as depreciation, interest earned, etc.

  • Profit & Loss Statement
  • Balance Sheet report
  • Receivables Reconciliation [Summary] report
  • Payables Reconciliation [Summary] report (Not Basics)
  • Trial Balance report

Annual reports

At the end of a financial year, your accountant will need, at minimum, a Trial Balance [Summary] report, a year-end Balance Sheet report, and a year-end Profit & Loss Statement report. You should check with your accountant before you prepare these reports, as you may need to enter some adjustment transactions.

The following reports can be prepared annually or as required:

  • Profit & Loss Statement report
  • Profit & Loss [With Last Year] report
  • Balance Sheet report
  • Balance Sheet [Last Year Analysis] report
  • Receivables Reconciliation [Summary] report
  • Payables Reconciliation [Summary] report (Not Basics)
  • Trial Balance report

See also: Month-end procedures and End of period procedures.

For third parties

Overview reports for your bank

If you need to provide your bank with financial information about your business, you can print the following reports:

  • Profit & Loss Statement report
  • Profit & Loss [With Year to Date] report
  • Profit & Loss [Budget Analysis] report
  • Balance Sheet report
  • Receivables Reconciliation [Summary] report
  • Payables Reconciliation [Summary] report (Not Basics)

Overview reports for your accountant

If you need to provide your accountant with financial information about your business, you can use the following reports.

  • Trial Balance report
  • Profit & Loss [With Year to Date] report
  • Balance Sheet report
  • Receivables Reconciliation [Summary] report
  • Payables Reconciliation [Summary] report (Not Basics)
Compliance

GST reporting and deposits

Use the following reports to prepare BAS (Australia) or GST (New Zealand) returns.

For a summary overview of GST collected and paid use:

  • GST [Summary - Accrual] report (Australia)
  • GST [Summary - Invoice] report (New Zealand)

For a detailed view use:

  • GST [Detail - Accrual] report (Australia)
  • GST [Detail - Invoice] report (New Zealand)

If you are allowed to remit sales GST on a cash basis (remit GST only on money received, not on sales booked), use the ‘Cash’ (Australia) or 'Payments' (New Zealand) versions of the above reports.

Payroll tax reporting and deposits (Plus and Premier, Australia only)

For payroll tax reporting and deposits, you can use the following reports:

  • Payroll Summary report (Payroll Categories)
  • Amount by Category (Payroll Tax) report
  • Payroll Tax report
 
Related topics