Skip to content
D
Documentation

Reports and audit work

reference
7 min readUpdated

What these reports are for

Reports and audit work turn accounting activity into views you can use for daily review, financial review, partner balances, tax work, journal review, audit history, product margins, cash-flow work, accounting tests, and product categories. Use this page when you need to choose a report, set its reporting options, run it, or understand a report-related validation message.

The work moves from accounting activity to review:

If you need to…Go to
Review journals, bank activity, or daily movementsAccounting journals and bank activity and Run a daily report
Choose and run a financial, partner, tax, or ledger reportFind the report you need, then Run financial, partner, tax, and ledger reports
Review analysis, audit history, margins, categories, or testsReview analysis, audit, margin, category, and test surfaces
Configure report access and administrative report workConfigure reports and audit work
Understand the accounting hub before choosing a reportAccounting dashboard
Resolve a message that is not specific to these reportsGeneral error messages and Common issues and solutions

Before you start

Prerequisites

  • Have the reporting period ready. Shared report options use Start Date and End Date.
  • Know which Journals and Company provide the accounting activity for the report.
  • Know whether the report needs Target Moves, a partner, an account, an analytic account, or another report-specific filter.
  • Have the access required by the destination. The Company column in Invoice Analysis requires multi-company access. Accounting Tests requires technical access. Multi-currency options in Journals Audit and Partner Ledger require multi-currency access.

The common report options use Target Moves, Start Date, End Date, the journal selection, and Company. Company is hidden on the report option form; the journal choices are constrained by the selected company.

Find the report you need

Use the Accounting reporting destinations to open the report that answers your question.

Prerequisites

  • You know whether you need a daily, financial, partner, tax, journal, audit, analysis, margin, category, or test report.
  • You have the access described in Before you start.

Steps

  1. Open the reporting destination that matches your question.

    If you need to…Open
    Analyse invoice amounts and dimensionsInvoice Analysis, the invoice review surface
    Review cash-flow forecastsCash Flow Forecast
    Open saved generated reportsGenerated Reports
    Work with report templatesCustom Report Templates
    Run accounting testsAccounting Tests
    Maintain account reportsAccount Reports
    Run a daily, partner, tax, journal, ledger, or balance reportOpen the named report from the corresponding Reporting destination, then continue with Run a daily report or Run financial, partner, tax, and ledger reports.

Result: The report destination matching your question is open.

Run a daily report

A daily report reviews movements for a selected period. Bank Book, Cash Book, and Day Book each provide report options and a Print action.

Prerequisites

  • You have opened Bank Book, Cash Book, or Day Book.
  • You know the period and the journals to include.

Steps

  1. Choose the daily report you need.

    If you need to review…Use
    Bank activityBank Book
    Cash activityCash Book
    Day-level activityDay Book
  2. Set the report options.

    ReportOptions
    Bank BookTarget Moves, Sort by, Display Account, Initial Balance, Start Date, End Date, Accounts, and Journals
    Cash BookTarget Moves, Sort by, Display Account, Initial Balance, Start Date, End Date, Accounts, and Journals
    Day BookTarget Moves, Start Date, End Date, Journals, and Accounts
  3. Choose the action that matches what you want to do.

    If you want to…Select
    Submit the daily report optionsPrint
    Close the report options without submittingCancel

Result: The selected daily report options are submitted.

Run financial, partner, tax, and ledger reports

These reports apply shared period and journal options to financial statements, partner balances, tax work, journal review, and ledger review.

Prerequisites

  • You have opened Aged Partner Balance, Balance Sheet, General Ledger, Journals Audit, Partner Ledger, Tax Reports, or Trial Balance.
  • You know the reporting period and the journals to include.
  • For Aged Partner Balance, have a positive Period Length (days) and a Start Date.

Steps

  1. Choose the report that answers your question.

    If you need to review…Use
    Balances by partner and ageing periodsAged Partner Balance
    A financial statementBalance Sheet
    Account movementsGeneral Ledger
    Journal entriesJournals Audit
    Partner movementsPartner Ledger
    Tax activityTax Reports
    Account balancesTrial Balance
  2. Set the shared options Target Moves, Start Date, End Date, Journals, and Company.

  3. Set the report-specific options.

    ReportAdditional options and conditions
    Aged Partner BalancePeriod Length (days), Receivable, and Partners. Period Length (days) defaults to 30, and Start Date defaults to the current date.
    Balance SheetAccount Report, Enable Filter, Debit/Credit, Label Filter, Comparison, Comparison Start Date, and Comparison End Date. Label Filter is required when Enable Filter is true. Debit/Credit is hidden when Enable Filter is true. Comparison Start Date and Comparison End Date are required when Comparison is set to the date filter.
    General LedgerAnalytic Accounts, Accounts, Partners, Sort by, Display Account, and Initial Balance. An initial balance requires Start Date.
    Journals AuditMulti-currency and Sort by. Multi-currency requires multi-currency access.
    Partner LedgerPartners, Receivable/Payable, Multi-currency, and Reconciled. Multi-currency requires multi-currency access.
    Tax ReportsUse the shared options.
    Trial BalanceDisplay Account and Analytic Accounts.
  4. Choose the action that matches what you want to do.

    If you want to…Select
    Submit the report optionsPrint
    Close the report options without submittingCancel

Result: The selected financial, partner, tax, journal, ledger, or balance report options are submitted.

Review analysis, audit, margin, category, and test surfaces

Each surface answers a different review question:

If you need to review…Surface and reader-facing information
Invoice amounts and invoice dimensionsInvoice Analysis provides Invoice Number, Journal, Customer, Country, Invoice Date, Due Date, Salesperson, Product Category, Product, Company, Average Price, Quantity, Untaxed Total, Total, Margin, Inventory Value, Status, Payment Status, and Type. It offers graph and pivot views.
Changes recorded in the audit historyAudit Trail provides Record, Date, Author, Name, Preview, Move, Account, Tax, Partner, and Company.
Product margin optionsProduct Margins provides From, To, and Invoice State, then Open Margins and Cancel.
Product categoriesProduct Categories provides Products, Category, Parent, and Product Category.
Account-report definitionsAccount Reports provides Name, Parent, Sequence, Type, Sign, Style Overwrite, Display Detail, Account Report, Accounts, Account Types, and Child Reports.
Accounting test definitionsAccounting Tests provides Sequence, Name, Description, Active, and Code. Access requires technical access.

When you select Type, the account-report form shows either Accounts or Account Types according to that selection.

On Product Categories, select Products to open the related products. On Product Margins, select Open Margins after setting From, To, and Invoice State. Use the related configuration pages when your work is about accounts, taxes, or journals rather than the report view itself: Accounts, taxes, and currencies and Accounting journals and bank activity.

The report destinations may open the application shell or an empty surface instead of a report form. When that happens, the shell is not the report screen.

The application shell includes these controls:

AreaControls
AppearanceMenu Style, Font Type, Preloader Option, and Theme Colors
ColoursBrand Color, Background Color, and Sidebar Color
DiscussionChatter Position
Shell settingsSave and Reset To Default

Handle validation and rendering problems

Use the exact message on screen to choose the correction.

MessageWhat to do
You must define a Start DateIn General Ledger, set Start Date when you select Initial Balance.
You must set a period length greater than 0.In Aged Partner Balance, enter a positive value in Period Length (days).
You must set a start date.In Aged Partner Balance, enter Start Date.
Form content is missing, this report cannot be printed.The report cannot be printed while this message appears.

These report conditions change what you enter:

  • Label Filter is required when Enable Filter is true.
  • Comparison Start Date and Comparison End Date are required when the comparison filter uses a date.
  • Initial Balance in General Ledger requires Start Date.

Result: You know which value to correct before selecting Print again.

Know what to do next

Continue your accounting review from the report question that led you here:

Was this page helpful?

Download as PDF
Reports and audit work — SherketyERP