Accrual report .CSV file for Xero Manual Journal entry (header level, limited version)

Accrual report .CSV file for Xero Manual Journal entry (header level, limited version)

In ApprovalMax, the Bill accrual feature allows users to generate collections of open Bills using the ApprovalMax filtering and reporting capability. The resulting .CSV file will be transferred to Xero via its capability for importing manual journal entries.

Currently, ApprovalMax supports accrual report on header level (limited edition) and accrual report on item level that allows you to create accrual reports, generate journals based on them, submit them for approval, and ultimately post them to Xero.

This is how  a limited version works:

  1. In the main menu select your Organisation and open “Request reports” page under Reports section

  1. Click on the “NEW REPORT” button first, specify report name, select Bill workflow and then select the filter criteria you need.
  2. On the next screen select visible columns and click on the "CREATE" button.

  1. To generate the Bill accrual report, click on the "three dots" menu and select “Create accrual report for Xero”. 

  2. Fill in the mandatory fields: you need to enter the Bill accrual report narration, which will appear as the narration of the manual journal entry in Xero, the date, and the accrual account details. 
Please note: The date on Accrual report setup is only to set the date information in the column.

  1. Click on "Create" and your report will be generated automatically.

  1. Finally, go to the Manual Journals page in Xero, click on “Import” and select the file which was generated by ApprovalMax.
    The collection of line items from the selected Bills that are subject to accrual will now be added to the Manual Journal entry draft, ready for editing and posting within Xero.
Please note: the journal is bringing in GST inclusive values.
New extended version of accrual reports is available on the item level and allows you to filter the data for uploading more accurately, see the PO balance, select Net/Gross amount, approve an accrual report and automatically post it in Xero.

    • Related Articles

    • How to create a Line Item Accrual report and export it to a Manual Journal

      Creating Accruals* in ApprovalMax is a straightforward process that helps maintaining accurate financial data. * Accruals in ApprovalMax on Line Item level provide a comprehensive solution that allows you to create Accrual reports, generate journals ...
    • How to create a Xero Manual Journal

      Before creating a Manual Journal, you first need to set up and activate a Manual Journal workflow in ApprovalMax: Specify all users who will be allowed to create Manual Journals in the "Creation" step. By adding Requesters to this step, they get ...
    • How to upload a Manual Journal to ApprovalMax

      Manually entering data into journals can be a tedious task, particularly when dealing with large volumes of transactions. To streamline this process and save valuable time, ApprovalMax allows to upload Manual Journals in a predefined .csv format. ...
    • Line Item Accrual reports

      What are Accrual reports? Accrual accounting records revenues and expenses when they are incurred, regardless of when the respective cash transactions are made. This approach offers a more accurate representation of a company’s financial performance ...
    • Troubleshooting: potential errors during Manual Journal creation via a .csv file upload

      When uploading a CSV file for Manual Journal creation, you might experience certain errors. Below, you'll find details on what to then check and the corresponding solutions: Check Reason/Solution The file must be a CSV (Comma Separated Values) file. ...