You can export general ledger data from Paladin to your accounting software. This export can be done automatically by using an Paladin accounting integration for QuickBooks, Sage 50cloud or Microsoft Dynamics GP, or you can do it manually

This article defines the Paladin general ledger data categories. To learn how to export this data to your accounting integration, see these articles:

Paladin general ledger category descriptions

Note: The image that follows this table shows how accounting categories on the GL Summary tab (Maintain > Data Viewer) and Accounting  tab (File > Setup) map to the Comparative Revenue Report. 

  • To access the GL Summary tab, on the Maintain menu, click Data Viewer, click the GL Summary tab, specify a data range and click Get Data.
  • To access the Accounting tab to set up integration account mappings, on the File menu, click Setup, and then click the Accounting tab.

Paladin GL Summary tab category

Paladin Accounting tab category Description Number in image below
Cash [DR]

Cash from Sales

[Asset Accounts]

Total of cash payments. 1
Charge Card [DR]

Chg Card from Sales

[Asset Accounts]

Total of credit card payments. 2
Check [DR]

Check from Sales

[Asset Accounts]

Total of check payments. 3
External Charge [DR]

External Charge from Sales

[Asset Accounts]

Total of external charge payments, such payments made using Capital One Trade Credit (previously BlueTarp). 4

Paid Out [credit]

Paid Out Exp Act [debit]

Paid IN/OUT from Sales

[Asset Accounts]

Paid IN/OUT Expense Account

[Expense Accounts]

Total of cash added to the drawer to pay for miscellaneous goods, such as office supplies, lunch for employees, etc.  5
Coupons Redeemed [DR]

Coupon Redeemed as Payment

[Asset Accounts]

Total amount of dollars in coupons accepted from customers as payment 6
Revenue [CR]

Total of all Sales

[Revenue Accounts]

Total NET Revenue (Gross Revenue – Returns) of all revenue sources for the time period selected including Charges 7
Accounts Receivable [DR]

Accounts Receivable

[Asset Accounts]

Total amount of dollars charged to customer accounts 8
Accounts Receivable  [CR]

Accounts Receivable

[Asset Accounts]

Total amount of payments received for customer account charges 9

COGS Inventory [DR]

Inventory Asset [CR]

COGS from Inventory

[Expense Accounts]

Inventory Asset 

[Asset Accounts]

Total amount of dollars for costs of goods sold 10

Tax Expense Act [DR]

Tax A/P Liability Act [CR]

Tax Expense Account

[Expense Accounts]

Tax A/P Liability

[Liability Accounts]

 

Total amount of invoiced sales tax 11

ROA Discounts – Expense [DR]

ROA Discounts – Asset [CR]

 

ROA Discounts 

[Expense Accounts]

ROA Discounts 

[Asset Accounts]

 

Total amount of dollars in discounts given to customer account balances (like removing a service charge/late fee) 12

Inventory Asset – Received [debit]

Inventory Purchased [credit]

Inventory

[Asset Accounts]

Inventory Purchase Account 

[Liability Accounts]

Total amount in dollars of inventory purchased from suppliers 13

Inventory Shrinkage [DR]

Inventory Asset – Shrinkage [CR]

Inventory Shrinkage 

[Expense Accounts]

Inventory

[Asset Accounts]

Total amount in dollars of inventory lost or found (positive or negative) for the time period selected.

Example: The stock on hand (SOH) was 10. I haven’t sold the item, but when I counted it again there was only 8. If the item cost me
$5.00, I lost $10.00, -$10.00 in shrinkage due to an unaccounted for change in SOH.

14

Inventory Defective [DR]

Inventory Asset – Defective [CR]

 

Inventory Defective 

[Expense Accounts]

Inventory

[Asset Accounts]

Total amount in dollars of defective inventory items returned to the store by customers for the time period selected 15

 

Coupons Issued – Expense [DR]

Coupons Issued – Asset [CR]

 

 

Coupons Issued

[Expense Accounts]

Coupons Issued

[Asset Accounts]

 

Rich Rewards only: Total of coupons issued by the store. Not shown 

Revenue account values in the GL Summary include any tax that was charged to the customer.  To calculate the total revenue without tax, compute this value:

Net revenue without sales tax = Net Revenue(#7) – Total Sales Tax(#11).

GL Summary mapped to the comparative revenue report

If you have questions or suggestions about this information, contact support@paladinpos.com.

*Content is subject to change. For the most recent version, visit the Help Portal.
Printed on: 8/05/21