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>