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 main menu select your Organisation and open “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.

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

• Report scheduler (NetSuite)

  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 ...

• Where can I find the reporting function?

  To access the reporting feature, navigate to the main menu in the upper left-hand corner, select your Organisation and open "Reports" section: There are default reports already available, which can be adjusted if required: Bills pending approval ...

• 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 ...

• Restrictions for file upload

  During the creation of requests in ApprovalMax, you can attach files to a request or in comment section. However, some technical limitations do apply. Below are supported file extensions, size and number of files that can be attached: Here are the ...

• 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 ...