Preparing Your Accounts Receivable Import File
The accounts receivable import files you create can be in CSV, XLS, or XLSX format. Only one transaction type can be included in a single import spreadsheet.
The table below lists the columns that can be used in your Accounts Receivable import documents. Your column headings must exactly match the names shown here. Columns can be in any order in your import document.
Keep in mind the following:
- Payments, credit adjustments, credit memos, write-offs, and tax write-offs reduce the AR balance for the client.
- Debit adjustments or memos increase the AR balance.
- A miscellaneous charge is not a form of payment. It creates a new open item in the client’s account. Use it when you want to charge a client for something that is not the result of performing work. For example, you can create a miscellaneous charge for the charges incurred when your client pays by credit card.
| Transaction Types | Required Columns | Optional Columns | Notes |
|---|---|---|---|
| Payment |
|
Either the Invoice Number or the ClientID.SubID column must be present in your import file. You can include both columns in the import file, but only one is required. |
|
|
Credit Adjustment Credit Memo Debit Adjustment Debit Memo Tax Write-off Write-off |
|
|
The transaction date will be used in the check/reference date field for transaction types that include that field. Your entry in the Reason field should correspond with reasons set up by your firm in Practice Lists. |
| Misc Charge |
|
|
Miscellaneous charges are not distributed. |