Cash Receipts Journal Fields (Import/Export)

Deposit Ticket ID

Y

N

Alphanumeric - Deposit ticket ID for the transaction.

Customer ID

Y

Maybe

Alphanumeric - Customer ID for the transaction. Required only if a distribution is applied to an invoice.

Customer Name

Y

Maybe

Alphanumeric - Customer name for the transaction. Required only if the Customer ID field is not in the import file and none of the distributions are applied to an invoice.

Reference

Y

Y

Alphanumeric - Reference number for the transaction.

Date

Y

Y

Date - Date of the transaction. Must be in ##/##/## (month/day/yr) format.

Payment Method

Y

N

Alphanumeric

Cash Account

Y

Y

Alphanumeric - Cash account number for the transaction.

Cash Amount

N

<N/A>

Numeric (Real) - Net cash amount for the transaction calculated during the import process. This field is used for exporting only.

Sales Representative ID

Y

N

Alphanumeric - Sales representative ID for the transaction.

Sales Tax ID

Y

N

Alphanumeric - Sales tax ID for the transaction.

Total Paid on Invoice(s)

Y

Maybe

Numeric (Real) - The total amount of all the invoices paid if any of the distributions were applied to invoices. Required only if a distribution is applied to an invoice.

Discount Account

Y

Maybe

Alphanumeric - Discount account number for the transaction. Required only if a distribution is applied to an invoice.

Prepayment

Y

N

Boolean - Indicates the transaction is a prepayment; valid choices are [True] or [False], where True=prepayment & False=regular transaction.

Vendor Receipt

Y

N

Boolean - True only if the receipt is from a vendor, otherwise it's false.

AR Date Cleared in Bank Rec

Y

N

Date - If the transaction used a cash account on a receipt and was cleared in bank reconciliation, then this is the date it cleared. Otherwise, leave blank or exclude this field. Must be in ##/##/## (month/day/yr) format.

Number of Distributions

Y

Y

Numeric (Whole) – Number of distributions in the transaction; valid numbers are 1 to 147.

Invoice Paid

Y

Y

Alphanumeric – Invoice number which is being paid for a line of distribution.

Discount Amount

See Description Column

See Description Column

Alphanumeric – Discount amount for the invoice which is being paid for a line of distribution. For Apply to Invoices transactions, this field is available and required; for Apply to Revenues, this field is not available.

Disc Date Cleared in Bank Rec

Y

N

Date - If the transaction included a discount date and was cleared in bank reconciliation, then this is the date it cleared. Otherwise, leave blank or exclude this field. Must be in ##/##/## (month/day/yr) format.

Quantity

See Description Column

See Description Column

Numeric (Real) – Quantity for a line of distribution. For Apply to Invoices transactions, this field is not available; for Apply to Revenues, this field is available but not required.

Stocking Quantity

N

N

Numeric (Real) - The actual quantity used for costing. (Ignored on import if present.)

Item ID

See Description Column

See Description Column

Alphanumeric – Inventory item ID for a line of distribution. For Apply to Invoices transactions, this field is not available; for Apply to Revenues, this field is available but not required.

Serial Number

Y

Y

Alphanumeric - Serial number for a line of distribution. Each serial number will be listed on a separate line.

U/M ID

Y

Maybe

Alphanumeric - Used (and required) instead of Item ID if you sell in different quantities for an item.

U/M No. of Stocking Units

Y

Maybe

Numeric (Real) - Required if you sell in different quantities for an item.

Description

Y

N

Alphanumeric – Description for a line of distribution.

G/L Account

See Description Column

See Description Column

Alphanumeric - G/L account number for a line of distribution. For Apply to Invoices transactions, this field is not available; for Apply to Revenues, this field is available and required.

GL Date Cleared in Bank Rec

Y

N

Date - If the General Ledger account used on a chosen distribution was cleared in bank reconciliation, then this is the date it cleared. Otherwise, leave blank or exclude this field. Must be in ##/##/## (month/day/yr) format.

Unit Price

See Description Column

See Description Column

Numeric (Real) – Unit price for a line of distribution. For Apply to Invoices transactions, this field is not available; for Apply to Revenues, this field is available but not required.

Stocking Unit Price

N

N

Numeric (Real) - The actual price used for costing. Ignored on import if present.

Tax Type

See Description Column

See Description Column

Numeric (Whole) – Tax type for a line of distribution, valid numbers are 0 to 25 (0 for the tax authority, 1-25 for available tax types). For Apply to Invoices transactions, this field is not available; for Apply to Revenues, this field is available but not required.

UPC/SKU

N

N

Alphanumeric

Weight

N

N

Numeric - The weight of the item in the selected unit of measure.

Amount

Y

Y

Numeric (Real) – Amount for a line of distribution. A positive amount denotes a debit, whereas a negative amount denotes a credit.

Inventory Account

N

<N/A>

Alphanumeric - Inventory account number for a line of distribution; retrieved from the Inventory item list during the import process. This field is used for exporting only.

Inv Acnt Date Cleared in Bank Rec

N

N

Date - If the transaction used an inventory account and was cleared in bank reconciliation, then this is the date it cleared. Otherwise, leave blank or exclude this field. Must be in ##/##/## (month/day/yr) format.

Cost of Sales Account

N

<N/A>

Alphanumeric - Cost of sales account number for a line of distribution retrieved from the Inventory item list during the import process. This field is used for exporting only.

Cost of Sales Account Cleared in Bank Rec

N

N

Date - If the cost of sales account for a given line-item distribution was cleared in account reconciliation, then this is the date it cleared. Otherwise, leave blank or exclude this field. Must be in ##/##/## (month/day/yr) format.

Cost of Sales Amount

N

<N/A>

Numeric (Real) - Cost of sales amount for a line of distribution calculated during the import process. This field is used for exporting only.

Job ID

See Description Column

See Description Column

Alphanumeric - Job ID for a line of distribution. For Apply to Invoices transactions, this field is not available; for Apply to Revenues, this field is available but not required.

Note: When importing any combination of jobs, phases, or cost codes, you must separate the items with commas and enclose the entire string with quotes. For example: "jobid,phase,costcode" (Sage 50 Premium Accounting and higher).

Transaction Period

N

<N/A>

Numeric (Whole) - Period number for the transaction. Used in conjunction with the transaction number to identify where a transaction (which is composed of several lines of distribution) begins and ends.

Transaction Number

N

<N/A>

Numeric (Whole) - Transaction number for the transaction. Used in conjunction with the period number to identify where a transaction (which is composed of several lines of distribution) begins and ends.

Receipt Number

Y

N

Alphanumeric - Receipt number for the transaction.

Cardholder’s Name

Y

N

Alphanumeric - Name on credit card used for the transaction.

Credit Card Address Line 1

Y

N

Alphanumeric – Credit card billing address line 1 for the transaction.

Credit Card Address Line 2

Y

N

Alphanumeric – Credit card billing address line 2 for the transaction.

Credit Card City

Y

N

Alphanumeric – Credit card billing city for the transaction.

Credit Card State

Y

N

Alphanumeric – Credit card billing state for the transaction.

Credit Card Zip Code

Y

N

Alphanumeric – Credit card billing ZIP code for the transaction.

Credit Card Country

Y

N

Alphanumeric – Credit card billing country for the transaction.

Credit Card Information

Y

Maybe

This includes 4 fields:

Credit Card Stored Reference -This is an alphanumeric GUID that is used by Sage 50 behind the scenes to link with Sage Exchange.

Merchant ID - This is an alphanumeric ID that is necessary for entering and processing credit cards from within Sage 50. This ID is entered in Services>Credit Card Processing.

Last Known CC Number - Masked value for the credit card number that was used for the transaction. Format is XXXX-XXXX-XXXX-NNNN (where NNNN is the last 4 digits of the credit card number).

Last Known CC Expiration Date - Expiration Date for the credit card that was used for the transaction. Must be in MM/YYYY (month/year) format.

Note: This information is required if Credit Card Authorized Status = [1] (authorized).

Credit Card Auth. Code

Y

Maybe

Alphanumeric – Credit card authorization code for the transaction.

Note: This field is required if Credit Card Authorized Status = [1] (authorized).

Credit Card Authorized Status

Y

N

Boolean – Indicates the transaction was authorized using Sage Exchange; valid choices are [1] or [0], where 1= payment authorized and 0=payment not authorized.

Note: If [1] (approved), then Credit Card Number, Credit Card Expiration Date, Credit Card Auth. Code fields are required for import.

Credit Card Comment

Y

N

Alphanumeric – Credit card comment for the transaction.