G/L Report

The G/L Report details how The Edge interacts with QuickBooks. It is a useful tool in analyzing how The Edge data is translated into debits and credits. To use the G/L Report, you must first integrate The Edge with QuickBooks. See the section entitled Mapping The Edge with QuickBooks Accounts, for more information on this process.

To run the G/L report: Select Administrative ► QuickBooks ► G/L Report. The G/L Report window will appear.

Fields on this report filter include:

Sales Number			Allows you to specify a single sale number. Useful for seeing how a particular transaction will post or has posted to QuickBooks.
Old Sales #			Allows you to specify an old sales number.
Sale Date			Allows you to specify a sales period.
Sold To			Allows you to specify a customer or group of customers.
Sold By			Allows you to specify a sales associate.
Store			Allows you to filter by store.
Item Number			Allows you to specify a single item number. Useful for seeing how a specific item will post or has posted to QuickBooks.
Station			Allows you to filter by computer station.
Group by
	Store			Breaks down the report by store.
	Month			Breaks down the report by month.
	Date			Breaks down the report by date.
	G/L Account			Breaks down the report by the general ledger accounts in QuickBooks.
	Sale #			Breaks down the report by each transaction.
		G/L Account Type		Breaks down the report by account type, e.g., liability, payables, etc.
Show Details			Whether to show detailed information or just a summary.
Page Breaks			Whether or break to a new page by grouping options.
Unposted Items			Whether to include transactions that have not yet posted to QuickBooks.
Posted Items			Whether to include transactions that have already posted to QuickBooks.
VOID Sales			Whether to include sales that were voided.
Sales Transactions			Whether to display transactions made through point of sale.
Inventory Transactions			Whether to display changes made to the inventory (adding, deleting, etc.).
Multi-Line Memo			Whether or not to give a full (multi-lined) description of each transaction.
Show Full G/L Account Name			Check this box to see the entire QuickBooks account name, including the parent account name.

The results might look as follows:

Data fields returned on this report include:

Date	The date the transaction took place
Sale #	The sales number of the transaction
Item/Job #	Additional reference number for this transaction. This could be a sales number, item number, repair number, or special order number depending on the type of transaction involved.
G/L Account	The account in the QuickBooks General Ledger that this posted to.
Credit	The amount posted to this account as credit.
Debit	The amount posted to this account as debit.
Memo	Gives a description of this transaction.