Accounts receivable—open balances described
When importing subledger transactions from a CSV or Excel file you must assign fields in the file to Caseware fields in the subledger dataset type you select on import, so that the transaction data displays correctly in the engagement. This topic details the fields in the Accounts receivable—open balances subledger.
For more information on the subledger dataset descriptions, see Understand subledger data.
For more information on importing transaction data from CSV files, see Import the client’s transactions from a CSV.
| Field | Usage |
|---|---|
Transaction ID (ar_open_balance_transaction_id) | The unique identifier for the transaction of open accounts receivable (AR) includes the invoice and cash received. Data type: Text Required: No Primary key: The value of this field is used to form the unique identifier of this entry. |
Invoice Type (ar_open_balance_invoice_type) | The code value or indicator of the method by which the transaction debit or credit amount was extinguished or apportioned to the debt by the customer. Examples include check, wire transfer, cash, credit memo, invoice, interest-only invoice, and so on. Data type: Text Required: No |
Invoice Due Date (ar_open_balance_invoice_due_date) | The date payment is due from the customer. Not all transactions will have a due date (for example, credit memos). Aging of a receivable is usually calculated based on this date. Data type: Date Required: No |
Balance Amount (ar_open_balance_balance_amount) | The remaining balance monetary amount recorded in the functional or group currency. Data type: Money Required: No |
Reporting Balance Amount (ar_open_balance_balance_amount_reporting) | The balance monetary amount recorded in the reporting currency. Data type: Money Required: No |
Local Balance Amount (ar_open_balance_balance_amount_local) | The balance monetary amount in local currency. Data type: Money Required: No |
Original Amount (ar_open_balance_original_balance_amount) | The monetary amount for the original balance (original invoice amount) recorded in the functional or group currency. Data type: Money Required: No |
Original Balance Amount Local (ar_open_balance_original_balance_amount_local) | The monetary amount in the local currency (original invoice amount). Data type: Money Required: No |
Original Balance Amount Reporting (ar_open_balance_original_balance_amount_reporting) | The monetary amount recorded in the reporting currency (original invoice amount). Data type: Money Required: No |
Grouping Code (ar_open_balance_grouping_code) | A grouping mechanism for related items in a batch or grouping of invoices, such as the invoice grouping found in certain ERP systems. Data type: Text Required: No |
Amount Type (Debit / Credit) (ar_open_balance_amount_credit_debit_indicator) | Indicates whether the amount is a credit or debit. Data type: Text Required: No Possible values: |
Project ID (ar_open_balance_project_id) | The unique identifier for the project, from which accounts receivable (AR) is derived. Data type: Text Required: No |
Fiscal Year (ar_open_balance_fiscal_year) | The fiscal year in which Transaction Date occurs. Data type: Text Required: No |
Accounting Period (ar_open_balance_accounting_period) | The accounting period in which Transaction Date occurs. Data type: Text Required: No |
Description (ar_open_balance_remark) | A free-form text description. Data type: Text Required: No |
Customer Account ID (ar_open_balance_customer_account_id) | The identifier of the customer from whom payment is expected or to whom unused credits have been applied. Data type: Text Required: No Primary key: Second alternate. If Transaction ID is not present in the data, the value of this field is concatenated with the values of the other alternate fields to form the unique identifier of the entry, for example |
Customer Account Name (ar_open_balance_customer_account_name) | The name of the customer. Data type: Text Required: No Primary key: Third alternate. If Transaction ID is not present in the data, the value of this field is concatenated with the values of the other alternate fields to form the unique identifier of the entry, for example |
Invoice ID (ar_open_balance_invoice_number) | The unique identifier for each invoice. Data type: Text Required: Yes Primary key: First alternate. If Transaction ID is not present in the data, the value of this field is concatenated with the values of the other alternate fields to form the unique identifier of the entry, for example |
Invoice Date (ar_open_balance_invoice_date) | The date of the transaction, regardless of the date the invoice is entered. This is the date from which the due date is calculated based on the invoice terms. Data type: Date Required: No Primary key: Fourth alternate. If Transaction ID is not present in the data, the value of this field is concatenated with the values of the other alternate fields to form the unique identifier of the entry, for example |
Business Unit Code (ar_open_balance_business_unit_code) | Used to identify the business unit, region, branch, and so on at the level that financial statements are being audited. Data type: Text Required: No |
Other Reference Number (ar_open_balance_reference_number) | An identification number for an internally or externally generated transaction. Examples include check number, wire transfer number, or original document identifier). Data type: Text Required: No |
Other Reference Date (ar_open_balance_reference_date) | The date on an externally generated transaction. Examples include check date or wire transfer date. Data type: Date Required: No |
Sales Contract ID (ar_open_balance_sales_contract_id) | The unique identifier for the sales contract, from which accounts receivable (AR) is derived. Data type: Text Required: No |
Entry ID (ar_open_balance_journal_id) | The unique identifier for the journal entry. Typically autogenerated by the source system. Data type: Text Required: No |
Balance Currency (ar_open_balance_balance_amount_currency) | The functional or group currency related to the balance amount. Data type: Text Required: No |
Reporting Balance Currency (ar_open_balance_balance_reporting_currency) | The reporting currency related to the balance reporting amount for nonconsolidated reporting. Data type: Text Required: No |
Local Balance Currency (ar_open_balance_balance_local_currency) | The currency for local reporting requirements. Data type: Text Required: No |
Amount Currency (ar_open_balance_amount_currency) | The functional or group currency related to the amount. Data type: Text Required: No |
Amount Reporting Currency (ar_open_balance_amount_reporting_currency) | The reporting currency related to the amount for nonconsolidated reporting. Data type: Text Required: No |
Amount Local Currency (ar_open_balance_amount_local_currency) | The currency for local reporting requirements. Data type: Text Required: No |
