The Client Ledger Reports AutoFile is run for a specific client, as and when required. It automatically generates the reports from Xero Ledger, brings them into FYI and automatically files them. It can be run for any of your clients in FYI where you have been granted access to their Xero Ledger.
Client Ledger Reports that can be Automated
Reports that can be automated include:
- Profit and Loss
- Balance Sheet
- Bank Summary
- Budget Summary
- Trial Balance
If the amounts in the ledger change, simply re-run the batch to create a new version of the reports in FYI.
Client Ledger Reports AutoFile Automation Process
The Client Ledger Reports AutoFile automation process will have been configured for your practice. Refer to Client Ledger Reports AutoFile (Australia and UK).
Connecting an FYI Client to a Xero Ledger
To produce a batch of reports using the Client Ledger Reports AutoFile automation, the FYI client must first have been connected, within FYI, to their Xero Ledger. Before the Client Ledger Reports AutoFile process can run for a client, the FYI client needs to be connected in both Automation - Apps and in the Client - Apps.
Running the Client Ledger Reports AutoFile
To run the reports:
- In FYI, go to Clients and select the relevant client.
- Go to the Processes tab.
Note: If the Client Ledger Reports Autofile displays "Please connect client to Xero", this indicates that you have not yet connected the client to their Xero Ledger, within FYI. Refer Connecting Xero Ledger for each Client in Automation - Apps (Australia and UK) and to Client Apps.
- For the process Client Ledger Reports AutoFile, click Run.
- Select the Date Range - You are given the option to select the date to run the reports for. "Run as Defined" will use the Date Range that has been set up in the process, but any of the other options for the Date Range can be selected as required.
Select the Job - You are given the option to select the job to file the reports against. "Run as Defined" will use the Job that has been set up in the process if applicable, otherwise options for the Job can be selected as required.
Each of the reports in the process are imported from Xero Ledger and automatically filed in FYI according to the settings in the process.
Displaying the Reports
The reports that have been produced are accessed from the Client - Documents tab.
The list displays as follows.
Note: The reports produced in FYI use a generic layout. If you have customised your reports in Excel to have a different layout, the reports produced in FYI may have a different layout to these.
Re-Running the Automation
If the figures are updated in the Ledger, the automation can be re-run. By re-running the automation, a new version of the reports will be created. The reports will only be updated if you choose to run the process again.
To re-run the automation, select the client in the Client workspace, go to the Processes tab and click Run.
Losing access to the Client's Xero Ledger
If you lose access to a client's Xero Ledger, you will no longer be able to run the automation for that client. You need to link the client again. Refer to Connecting Xero Ledger for each Client in Automation - Apps and Client Apps.