Bulk updating invoices

Plan: Not Available: Intermediate, Pro Available: Elite

Users: Not Available: All users Available: FYI Admins or User Group permissions

Practice Management Source: Not Available: Xero Practice Manager, APS, Iris, MYOB AE & AO, CCH, MYOB Practice Management (formerly GreatSoft) Available: FYI

Bulk Update allows users with Create Invoice permission to update multiple invoices at the same time, helping practices efficiently manage invoice information.

Depending on the invoice status and the field being updated, different options may be available. For example, users can bulk update Draft invoice Invoice Date, update the Filing Status of invoices, or delete Draft invoices in bulk when they are no longer required.

Using Invoice Bulk Update

When bulk updating invoices, up to 10,000 invoices can be selected and bulk updated at one time. For large updates, it is recommended to run the bulk update at the end of the day to help reduce delays to other bulk update actions in FYI, or create an automation using the Update Invoice step to schedule the updates automatically.

To bulk update invoices:

  1. Navigate to an Invoice list, then select one or more invoices in the list.
    Review the invoices selected to ensure you have selected only the invoices that should be updated or deleted.
  2. Click the Bulk Update button in the toolbar.
    3579_Bulk_Update_Button.png
  3. The Invoice Bulk Update drawer displays.
    5260_invoice_bulk_update_drawer.gif
  4. Update the Invoice details you want to change.
  5. Apply to will default to the selected invoices in the list.
  6. Click Run. A message displays confirming that the Bulk Update has been scheduled. Click on the link to view the Practice Activity or check the Automation History for progress.

Invoice Bulk Update details

The following invoice details can be bulk updated in FYI. 

Invoice details Bulk Update
Invoice Date

The date assigned to the invoice. The Invoice Date can only be updated when the Invoice Status is Draft.

For Draft invoices, select from:

  • Current Date
  • Month End
  • A date selected from the calendar.

Merge Fields can also be used. For example, selecting End of Month from the General Merge Field section will populate a Date merge field.

Updating the Invoice Date also updates the Due Date based on your practice's Invoice Settings. For example, if invoices are due 7 days after the Invoice Date and the Invoice Date is changed from 1 September to 5 September, the Due Date is updated from 8 September to 12 September.

Filing Status

Update the Filing Status of an invoice. Select from:

  • Filed: Can only be run on Unfiled invoices. Select when the invoices are Unfiled and have already synchronised to the correct Client and Job. Filing the invoices creates an interim time entry.
  • Excluded: Select when the invoices do not need to be included in WIP reconciliation and should not have an interim time entry created.
  • Unfiled: Select when an invoice has been incorrectly marked as Filed and needs to be reviewed again. Updating an invoice to Unfiled automatically deletes the associated interim time entry. The invoice can then be reviewed and updated to Filed or Excluded as required.
Status

The Status to assign to the invoice. Draft invoices can be updated to Deleted. 

If the invoice Status is not Draft when the bulk update runs, the Status will not be updated.

Custom Field Select a Custom Field to update on the invoice.
Was this article helpful?
0 out of 0 found this helpful

Stay Up-To-Date

  • Events

    We host a range of product demos, training webinars, workshops and more.

  • Service Status

    Check for updates on the FYI Platform

  • What's New

    Round-up of new features, fixes, and other important announcements.