Reports in Xero

  • Reports In Xero
  • Aged Payables Summary – Use the Aged Payables Summary report to view the outstanding transactions as at the report date. The total amount listed includes all outstanding bills, credit notes, expense claims and overpayments. Bills that were awaiting payment on the report date are included, even if they’ve been paid since. (Monthly)
  • Aged Payables Detail – You can use the search field in the top right corner. next to the date to choose a set reporting period, eg End of last month or End of last quarter. (Monthly)
  • Account Transactions – The Account Transactions report shows transactions recorded in your Xero organisation. You can select which accounts to include, and which report period to look at. The report shows the accounts you select in alphabetical order by default.
  • Aged Receivables Summary- An accounts receivable aging report is an accounting document that gives the business an overview of its outstanding payments from customers and how long they are past due. Most businesses have accounts receivable in their accounting ledger.
  • Aged Receivables Details – Find and open the Aged Receivables Detail report. You can use the search field in the top right corner. next to the date to choose a set reporting period, eg End of last month or End of last quarter.
  • Balance Sheet – Reconciliation purposes (Monthly check)
  • Budget Variance- To see how our actuals are tracking against our budget. (Monthly)
  • Contact Transactions Summary – Summary report to see a summary of your receivable, payable and cash transactions for a contact over a period. (Fortnightly)
  • Depreciation Schedule- To trach Fixed asset values, movements and depreciation. (weekly Basis)
  • Fixed Asset Reconciliation- Fixed Asset Reconciliation report to compare your Balance Sheet fixed asset account balances with your asset register balances. (Monthly basis)
  • General Ledger Detail- activity and balances for all accounts. View the transactions within the accounts that appear in your chosen date range. (Monthly Basis to compare other reports)
  • Income and Expenses by Contact- Contact report to view expenses, receive money transactions and sales invoices for a set date range. (Weekly basis)
  • Inventory Item List- This report contains a full list of your inventory items in Xero Inventory (Products & services), including quantity and value on hand for tracked.
  • Payable invoice detail – Payable Invoice Detail report to view details of payable invoices (bills), credit notes and overpayments in each period. (Weekly)
  • Profit & Loss – Profit and Loss report to view income, expenses and profit. We can customise reports as required. (Fortnightly)
  • Receivable Invoice Detail- Receivable Invoice Detail report to view invoices, credit notes, and overpayments by line item. (Fortnightly)
  • Receivable Invoice Summary – lists sales invoices, credit notes and overpayments for the report period. We can include prepayments and quotes in the report. (Monthly)
  • Top Suppliers- Views Top suppliers with a chart or table for required period. (Quarterly)
  • Top Customers – View Top customers with a chart and table for required period. (Quarterly)
  • Bank Transactions by date- a list of all transactions, grouped by bank account, coming in and going out of your organisation. (Weekly Basis for reconciliation purposes)
  • Bank Statements/ Transactions from FNB- Download and file statements monthly in Folder, and crosscheck with Xero for reconciliation purposes.  (Monthly)
  • Payfast statements/ transactions –payfast transactions is daily received due to an automatic set up in Payfast, monthly statements can also be pulled manually.
  • Snapscan- Transactions/ Statements to be downloaded on site. (Weekly/Monthly) – not many customers using Snapscan.
  • Yoco Statements -Manually from Yoco site and file accordingly

Reports in MRP EASY

  • MRP Easy – CRM > Statistics > Customers/ Goods Shipped / Customer Orders
  • Production Planning > Statistics> Report> Costs by manufacturing orders> Costs by products > Manufacturing efficiency
  • Stock > Critical On hand report.
  • Stock > Inventory report.
  • Stock> Stock lots> warehouses.
  • Stock> Write off reports.
  • Stock> Stock movement report.
  • Purchase orders > CSV/ PDF Export.
  • Purchase orders> Statistics.
  • Export to CSV/ PDF