The Invoices Report displays a list of Outstanding Invoices grouped by Client and Job, including the Invoice Number, Date and Total. For each Client, the report will display the Job and an aggregation of the total invoiced amount for the Client.
Report Data
Report Tab
The Report tab leverages the Microsoft Excel Pivot Table functionality.
The Client rows will be expanded to display each Job, Invoice, Invoice Date and Total for each Invoice.
By default, the Invoices report shows all Invoice Statuses. A user can filter the data via the Excel filter functionality to display only specific invoice statuses, such as invoices that are "Awaiting Payment".
For practices with multiple Xero Ledger accounts, the report can be filtered to specific accounts using the Xero Ledger Account Filter.
Users will be able to customise the Pivot Table as required depending on their practice requirements. For more information, refer to Microsoft Support.
Data - Invoices Tab
The Data - Invoices tab will display columns as per the View configured in FYI. Refer to Default View below.
If Include All Columns was selected when generating the report, all columns available to the view will be included in the tab.
The Invoices data does not contain calculation formulas. It provides a clear overview, including client information, invoice details, and job details specific to the View configured when generating the report.
The FYI Job, FYI Invoice and Xero Invoice columns contain direct hyperlinks, to provide quick access to the corresponding information in FYI or Xero.
Report Settings
The Settings worksheet is used to manage the configuration options for the report, and a Change Log to track updates made to the report.
Variables
The Variables contain data that is used in the header section of the report. Making changes to the Variables can affect the accuracy and layout of your report, and should only be modified by experienced users.
Report Name
The Report Name is displayed on the Report tab, in the top left corner.
Practice Name
The practice name configured on the Settings tab will be displayed on the Report tab under the Report Name. By default, the practice's name from FYI will be inserted, but can be updated if required.
Report Date
Displayed on the Report tab under the Report Name and Practice Name, and is the date the report was run. If the report data is refreshed on a later date, this can be updated to show the newer date.
Change Log
The Change Log displays a record of all modifications to the template. When FYI releases new versions of reports, a summary of the changes will be added. Practices can also use the Change Log to document any custom changes they make to their own reports.
Default View
The Report Template configuration in FYI allows users to select the Views to be included in the report. Each selected view in FYI will generate a corresponding "Data" tab in the Excel report.
The views selected can be found by looking at the Filing section of the Report Template in FYI.
For the Invoices report, an Invoices view is selected by default, and will create the Data - Invoices worksheet. Practices can add more views if required, by selecting a View Type, then selecting a View.