Table of Contents
Accounts Receivable Sample
Accounts Receivable import samples are available in the following file formats:
Microsoft Excel Worksheet
Account ID | Account Number | Account Name | Fund Name | Entry Type | Transaction Amount | Transaction Date | Transaction Number | Memo | Payment Method | Transaction ID | |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | DIV-A | Division A | Property Insurance | Payment | 4500 | 07/01/2021 | 002535 | Pay annual premium | Check | ||
2 | DIV-B | Division B | Auto Insurance | Debit Memo | 515.91 | 09/12/2021 | Added new vehicle | ||||
3 |
JSON File
{
"accountsReceivable": [
{
"accountId": "",
"accountNumber": "DIV-A",
"accountName": "Division A",
"fundName": "Property Insurance",
"entryType": "Payment",
"transactionAmount": "4500",
"transactionDate": "07/01/2021",
"transactionNumber": "002535",
"memo": "Pay annual premium",
"paymentMethod": "Check",
"transactionId": ""
},
{
"accountId": "",
"accountNumber": "DIV-B",
"accountName": "Division B",
"fundName": "Auto Insurance",
"entryType": "Debit Memo",
"transactionAmount": "515.91",
"transactionDate": "09/12/2021",
"transactionNumber": "",
"memo": "Added new vehicle",
"paymentMethod": "",
"transactionId": ""
}
]
}
XML Document
<?xml version="1.0"?>
<import>
<accountsReceivable>
<accountId></accountId>
<accountNumber>DIV-A</accountNumber>
<accountName>Division A</accountName>
<fundName>Property Insurance</fundName>
<entryType>Payment</entryType>
<transactionAmount>4500</transactionAmount>
<transactionDate>07/01/2021</transactionDate>
<transactionNumber>002535</transactionNumber>
<memo>Pay annual premium</memo>
<paymentMethod>Check</paymentMethod>
<transactionId></transactionId>
</accountsReceivable>
<accountsReceivable>
<accountId></accountId>
<accountNumber>DIV-B</accountNumber>
<accountName>Division B</accountName>
<fundName>Auto Insurance</fundName>
<entryType>Debit Memo</entryType>
<transactionAmount>515.91</transactionAmount>
<transactionDate>09/12/2021</transactionDate>
<transactionNumber></transactionNumber>
<memo>Added new vehicle</memo>
<paymentMethod></paymentMethod>
<transactionId></transactionId>
</accountsReceivable>
</import>