Custom Transaction CSV File Examples
When importing a custom transaction, you can use a single CSV file or multiple files.
Multiple Files Import
If you are using multiple CSV files, you should include one file for the body data and an additional file for each sublist that requires data. For example, if you want to include data for the Lines sublist, you include a file for that sublist. If you want to include data for the Accounting Books sublist, include a file for that sublist.
The following table shows how you might format the file that holds the main transaction body data.
|
External ID |
Status |
Subsidiary |
Class |
|---|---|---|---|
|
1015A |
A |
1 |
6 |
|
1016A |
B |
1 |
8 |
The following table shows how you might format the secondary file. In this example, the transaction type uses the journal style, so each line must include a value for either the Credit or Debit field.
|
External ID |
Fixed Asset Accrual Lines: Account |
Fixed Asset Accrual Lines: Credit |
Fixed Asset Accrual Lines: Debit |
|---|---|---|---|
|
1015A |
6 |
1000 |
— |
|
1015A |
8 |
— |
1000 |
|
1016A |
6 |
1952 |
— |
|
1016A |
14 |
— |
952 |
|
1016A |
18 |
— |
1000 |
Single File Import
With the single-file approach, all data for all records is included one file. If the transaction is to include more than one line, each line is represented by its own line in the CSV file.
The following example shows how to create two instances of a custom transaction type that uses the basic list style. In this case, each record has two lines in the Lines sublist.
|
External ID |
Memo |
Status |
Subsidiary |
Bad Debt Lines: Account |
Bad Debt Lines: Amount |
|---|---|---|---|---|---|
|
101A |
Approved by John |
B |
Parent Company |
6 |
1000 |
|
101A |
— |
— |
— |
8 |
1700 |
|
102A |
Approved by Mary |
A |
Parent Company |
6 |
2500 |
|
102A |
— |
— |
— |
10 |
500 |
The following example shows how to create two instances of a custom transaction type that uses the journal list style. This file is set up in a similar fashion. However, note that the Lines sublist requires values in the Credit and Debit fields. You do not enter a value for Amount.
|
External ID |
Status |
Subsidiary |
Fixed Asset Depreciation Lines: Account |
Fixed Asset Depreciation Lines: Credit |
Fixed Asset Depreciation Lines: Debit |
|---|---|---|---|---|---|
|
105A |
Awaiting approval |
1 |
1 |
1000 |
— |
|
105A |
— |
— |
2 |
— |
800 |
|
105A |
— |
— |
3 |
— |
200 |