Start a conversation

How can I post my closed batch data to the General Ledger in my accounting software?

The following assumes you will utilize the two-step export/import feature in Store Operations to post your batch data to a file and import that data into Quickbooks or another accounting package. However, you can also use this method to post your closed batches to a file and review those entries in Wordpad or Excel. To do so, run Manager | File | Configuration | Accounting and set the selection to Quickbooks File. Now proceed to Journal | Assign GL Entries to view the data which can be posted from closed batches.

This is the same data summarized on the Register Analysis report, and collected from the Z report generated at each register.

To export this data to a file, select Journal | Post Closed Batches | File Name. The default will be .iif (QuickBooks format), but you can change this to .txt or .asc (ascii) which can be read using Notepad or Excel.

To import the file run Quickbooks and select File, Utilities, Import (IIF).

IIF stands for Intuit Interchange Format. This method of integrating information with QuickBooks allows you to exchange highly formatted text files with QuickBooks through the File/Utilities menu.

Open the attached file below for details on the GL entry definitions.

Note: When running RMS version 2.0.100x or higher there is a separate GL entry for RMS voucher sales (gift cards) versus redemption by gift card (tender type).

IMPORTANT: We do not support nor recommend the XML method of pushing data to Quickbooks (labeled Quickbooks 2003 or later). This method has a number of reported issues and is not supported in all versions of Quickbooks.

GL_Account_Setup.pdf

  1. 11 KB
  2. View
  3. Download
Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Dave J

  2. Posted

Comments