This procedure shows you how to manually create and export a general ledger summary from Paladin.

Tip Paladin integrates with QuickBooks, Sage 50cloud and Dynamics GP to automatically transfers the day’s general ledger activity summary to your accounting software each night. Learn more

  1. Open Paladin.
  2. Recommended: If you have not entered account number 7 with a from your accounting software into Paladin, we recommend that you do–especially if you will be importing the data into your general ledger/chart of accounts. Follow the instructions for your accounting program.

  3. On the Maintain menu, and then click Data Viewer.
  4. In the Paladin POS Data Viewer, click the GL Summary tab.
  5. In the Date Range boxes, select a date range for your data.
  6. Optional: Select Show by Department to view revenue itemized by department. This option is best for viewing or saving the data, and is not recommended if you will be importing the file into an accounting program.
  7. Optional: Select Include $0 Amounts in Export to include accounting categories with $0 amounts in the export file. By default, $0 amounts are not included in the export.
    Note: This option requires Paladin Release 2021-D or build 4510 which is not in all stores.
    Itemize by department in the General Ledger Summary report
  8. Click Get Data. The data will appear in the Totals Balance pane. 
    Tip: To learn more about these general ledger data values, see Overview: Paladin Accounting (General Ledger) categories
  9. To export the data, in the Export list, select a format for exporting the data.
    • QuickBooks: Select the QuickBooks version. If your QuickBooks version is not listed, select Tab Delimited.
    • Tab Delimited: Select for other accounting programs or to view the data in Excel.
    • Tab Delimited With Dates: This option adds the store name and date range of the summary at the beginning of the export file. If you view the export file in Excel, this information will appear in the first row. This option is not recommended if you will be importing the file into an accounting program.
      GL Summary Excel report with store name and dates
  10. Click Export.
  11. In the Save As window, browse to the location where you want to save the file.
  12. In the File name box, enter a name for the file.
  13. Verify that the export file type is correct:
    • Quick Book Files: Select for QuickBooks exports.
    • Text (.txt) Files: Select for tab-delimited exports.
  14. Click Save.
  15. Optional: Import the file into your accounting software.

Paladin accounting software integrations

To learn more about how you can automatically transfer the day’s accounting totals into your accounting software, view the overview for your accounting program.

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: 9/23/21