Running the Client Ledger Reports AutoFile (Australia and UK)

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.

Refer to Connecting Xero Ledger for each Client in Automation - Apps (Australia and UK) and to Client Apps.

Running the Client Ledger Reports AutoFile

To run the reports:

  1. In FYI, go to Clients and select the relevant client.
  2. Go to the Processes tab.

    790 Client Processes tab.gif

    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.

    1524_Xero_Ledger_Client_Not_Connected_.gif
  3. For the process Client Ledger Reports AutoFile, click Run.
    1525_Run_Xero_Ledger_Client.gif
  4. 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.
    043A_Xero_Ledger_Run_Process.gif

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 is displayed as follows.

589_NL_Client_Ledger_Reports.gif

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.

Was this article helpful?
0 out of 0 found this helpful