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.

To access the COGS Summary go to: 

Modules > Accounting Exports > Cost-of-Goods Sold Summary

• This will open the Find Cost of Goods Sold Export Batch screen.
• You can find an existing batch to export, or you can create a new batch. 
• More often than not, you will create a new batch to export.

A G/L Export batch for the Cost-of-Goods Sold Summary is nothing more than a set of products broken down by G/L Codes, grouped together  by a date range, and, if desired, by store. 

To create a New G/L batch, at the Find Cost of Goods Sold Export Batch screen, 

• 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.