This bulk operation allows you to create opening balances on customers in your Stax Bill account. Typically an opening balance is done when migrating a customer to Stax Bill with existing balances or deposits on file.
The opening balance allows you to set a balance on deposit or a balance owing on newly created customers who have been migrated and are activated in Stax Bill.
The following are the field requirements. The Stax Bill ID is the only mandatory field.
FieldSet Definitions
|
Field name |
Description/Value |
|
StaxBillId |
Stax Bill Id |
|
AmountOnDeposit |
The amount on deposit. e.g. 134.56 |
|
AmountOwing |
The amount that a customer owes. e.g 345.67 |
|
Terms |
The net terms. e.g. Net30. A null value will use customer default. |
|
PoNumber |
An integer that will be displayed on the invoice with the PO Number label. |
|
OpeningBalanceOwingChargeDisplayName |
This is a string that will appear next to the charge. e.g. Bronze Plan |
|
OpeningBalanceChargeDescription |
This is a string that would appear below the Charge Display name. |
|
OpeningBalanceReference |
A string reference value that will appear on the transaction details. |
|
InvoiceNote |
A string value that will be displayed in the invoice note section. This can be 256 characters in length. |
Restrictions
- Maximum of 1000 customers per batch.
- Customers must have a Stax Bill ID and be active.
- Webhooks are not generated for records processed by a bulk job.
- Calls to 3rd Party tools (Salesforce / QuickBooks / NetSuite) are not sent for records processed by bulk jobs.
To set opening balances on customers, complete the following:
- On the Jobs page, click View Import Jobs.
- On the Import page, click Create Import.
- On the Bulk Import window, select the Import Type Opening Balance; then select the Import Action Create 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.
- Edit the starting file with the values to be updated and save.
- 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.