Accrual report .CSV file for Xero Manual Journal entry

Accrual report .CSV file for Xero Manual Journal entry

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.

This is how it works:

  1. In the Organisation menu, open “Reports”.
  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.
This will be fixed once we rework the Accrual report system.
There is unfortunately not yet an ETA as of when the fix will be released.

    • Related Articles

    • Where can I find the reporting function?

      To access the reporting feature, navigate to the main menu    in the upper left-hand corner and select "Reports" under your Organisation: There are default reports already available, which can be adjusted if required: Bills pending approval Purchase ...
    • Why are audit reports sometimes not attached to the Xero document?

      Xero does limit the amount of attached files — there can be no more than 10. If a Bill or Purchase Order that was created in Xero already has the allowed 10 attachments, ApprovalMax cannot add the audit report because this would exceed the stipulated ...
    • Line item reports (Xero)

      You can generate reports with line item details and also schedule the report generation and delivery to selected email addresses. Line item reports allow you to look deeper into your accounts payable and accounts receivable to understand what exactly ...
    • Report scheduler (Xero)

      Instead of generating reports manually every time you need one, you can schedule the creation and specify who you want to receive such report – everybody will find it in their inbox right on time.  Depending on your needs, scheduled reports can be ...
    • Are audit reports sent to the customer with the Sales Invoice?

      Xero has 2 types of attachments for Sales Invoices: Those to be sent with the Invoice Those not to be sent with the Invoice ApprovalMax attaches PDF audit reports as "Those not to be sent with the Invoice". So you will not send an audit report by ...