Clicking on any one of the buttons will bring you into similar looking find screen.

Here you select existing batches or you can create new ones.

More often than not, you will be creating a New batch

The steps for creating a batch for every option except for Vendor Invoice Approvals and Vendor Credit Memos are the same.

The results of the batches will be different based on your selection.

To learn more about their intricacies click on the one you'd like to learn more about.  

Vendor Invoice Approvals

Vendor Credit Memos

Otherwise to Create a New batch for all other options:

• Select the desired Export from Modules > Accounting Exports
• Click on the New button in the Task Bar. 
• This opens the Accounting Export Batch window, where you will create the new batch.
• Batch Date: Choose the date you want to use as the starting point for the batch. 
  • The Batch Date field will default to yesterday's date, but you can change it to whichever date you want. 
• Batch Status: will be grayed-out  
  • This is informational and cannot be changed.
  • It lets you know whether the batch you are currently working on is editable, verified, or already exported.
• Click on the Select Transactions button
  • This opens the Accounting Export Selection window. 
    • In From and Through: Select the desired date range for the batch
      • The date you already selected in the Batch Date field from the Accounting Export Batch window will appear. 
    • Select Transaction from All Stores:
      • Checked = Yes
      • Unchecked = No
        • The Select Transaction from Store field is now accessible
        • Click on the Binoculars
        • Double Click on desired store
    • Click on the Select transactions button 
      • The system will display a series of message boxes, updating you on what it's doing
      • When complete a Totals box will display the total dollar amounts and other totals figures for the transactions/onhand adjustments within the batch. 
      • Then, you are taken back to the Accounting Export Batch window
• The table at the bottom portion of the screen will be filled in with specific batch information.
• All of the different G/L Codes included in the batch will appear as their own line item. 
  • Products that did not have G/L Codes attached to them will display as "Unassigned."
  • If there is a General Ledger Store Code, that will appear under the second column.
• Batch ID: is the batch number assigned to this batch.
  • This is system-generated, and it begins with #1. This number is significant. 
  • Every product included in this G/L batch will be tagged with the Batch ID number.  
  • Batch IDs are unique throughout all of the G/L Exports.
• Transaction $ column: This is shown for each G/L Code (row) in the list, and is a total dollar amount for the G/L Code in this batch. 
  • e.g. if 10 products with a G/L Code of FF had onhand adjustments, the Transaction$ amount would be the combined dollar amount for all 10 onhand adjustments. 

Keep in mind, this list in the Accounting Export Batch window is organized by G/L Code, not product.

Each individual G/L Code included in the batch displays on the list. 

Now that you know how to create a batch, please take notice of a couple of informational fields in the Accounting Export Batch Properties section of the screen

Created by: system-generated and informational. 

• It cannot be changed. It simply lists the logged-in user's name who created the batch. 
• The field to the right of it lists the date and time the batch was created.

Last exported: system-generated and informational 

• It lists the logged-in user's name who last exported the batch to an external accounting system. 
• The field to the right lists the date and time the batch was last exported. 

Version: fills in automatically.

• The first time the batch is exported, the Version is 1.
• If it's exported a second time, the Version is 2, and so on.

Prior to exporting the batch, be sure which file format you plan to use. 

• Export File format: Click on the down arrow and choose either: CSV Comma Seperated, IIF Quick Books, or Transaction Pro CSV

Click on the Create Export file button. 

• The standard Windows Save dialogue box appears
• Once complete, a message displays letting you know the file has been exported successfully. 
  • The Last exported by field has been automatically filled in, along with the date and time and Version to the right of it.
• You are done!

You have created a G/L batch for the Cost-of-Goods Sold Summary and exported it.

You can do this process on any set schedule of your choosing.

Note: If you need to select an existing G/L batch (perhaps you need to review the information again or run the export again for some reason), back at the Find Cost of Goods Sold Export Batch window, use standard Find techniques to select the G/L batch you wish to access.

When the batch appears in the grid at the bottom of the Find screen, double-click on it.

This will take you to the Accounting Export Batch window, where you can do what you need.

A G/L export batch for the POS Transaction Summary is a set of transactions, broken down by G/L Codes for products, services, tenders, and tax codes, grouped together. 

They are grouped together by a date range, and, if desired, by store. 

It will tabulate your debits and credits for a specified date range for POS transactions.

Example POS Transaction Export Below --

Each line from the POS Transactions export file is an ACCOUNTING GL Code from your list under TOOLS / PARAMETERS / ACCOUNTING GL CODES

- The Clearing House Account is a holding account for all of the tender accounts they are using.  The following is an example of taking CASH as a tender and the accounting category for that tender uses a CLEARING HOUSE ACCOUNT to summarize the totals.  If you want those broken out separately, just create a separate Accounting GL Code for each type of tender you want to see in your report.  

The Cost-of-Goods Sold (COGS) Summary is where you run a G/L Export for Inventory Changes.

This can be done either via sales at the POS

or

Non-sale onhand adjustments summarizing by G/L Ledger Code, the dollars recorded by inventory changes on your system. 

This export will take into account any product whose onhand amount has changed, for whatever reason. 

Note: This export does not apply to services, tax codes, tenders, or products whose inventory is not tracked by the system.

A G/L export batch for a Vendor Invoice Approval is essentially a listing of all products assigned to an invoice from the vendor you purchased them from.

This program enables you to select an invoice number and then compare your costs as tabulated in iMerchant against the vendor's charge on their actual invoice slip.

Prior to exporting a batch, iMerchant will force you to get rid of any variance that might be present.

Vendor Credit Memos is where you run a G/L Export that summarizes the dollar value for products that you have returned to vendors. 

This is where you will check what you have returned (per your data in iMerchant) against the vendor credit memos.

The Imported Sale Transaction Summary is where you run a G/L Export for transactions that have not already been posted during the time period you select. These transactions are summarized by G/L Ledger Code. 

Note: A G/L export batch for the Imported Sale Transaction Summary is nothing more than a set of transactions, broken down by G/L Codes for products, services, tenders, and tax codes, grouped together.

They are grouped together by a date range, and, if desired, by store.