The Bulk Manual Payment Recording feature allows our clients to record manual payments across multiple customers in a single batch job process. You can use this feature whenever you need to record multiple cheques or wire transfers across your customer base and want to save time by not needing to manually record each payment on each customer individually.
To access the Bulk Payment Import feature, complete the following:
- Navigate to Jobs > Imports.
- On the Import page, click Create Import.
- On the Bulk Import window, select an Import Type; then select an Import Action and click Next.
- On the Choose an Import File window, click Choose File to select a file. If you do not have a file with the proper format, click Export starting data file. This file will contain the structure required to import or edit the bulk action. Note that you may be required to specify additional information based on the type or action of the Bulk job. Select include invoice allocation columns to apply the payment to a specific invoice in Stax Bill.
- Edit the starting file with the values to be updated and save. You will need to delete the descriptions in row two.
- Click Choose File to upload the edited starting data file and click Upload File.
- The file will be validated for structure. Click Record Validation.
- The Record Validation window will display the number of records processed and any errors encountered. Click Import Validated Records.
- On the Import Complete window, processed records and any errors will be displayed.
- The job will be initiated and depending on size may take a few minutes to complete. Click Close.
Required CSV Format:
StaxBillID |
(Required) - identifies the target customer that the payment should be applied. Any Stax Bill ID you specify must belong to your account. You can have multiple entries in the list for the same Stax Bill ID. |
Amount |
(Required) – the amount in currency format for the desired Payment |
Reference |
(Optional) – a string to help identify the payment in reports. |
Type |
(Required) – Allowable values are:
|
AllocationGroup |
(Optional) –Integer value used to group allocations based on the same payment. You can use an integer to specify that the payment amount will be divided among many invoices. A line with the same Stax Bill ID and allocation group will only count the one payment but will allocate to many invoices. |
AllocationInvoice |
(Optional) – The Stax Bill invoice to allocate the AllocationAmount funds to. |
AllocationAmount |
(Optional) – The amount to be allocated to the specific invoice specified in AllocationInvoice. The allocation amount must be equal to or less than the invoice. Overpayments will error. |