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:

  1. Select Administrative > QuickBooks > G/L Report.  The G/L Report screen 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.

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

    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.

 

 

Updated on Tue, 01 Jun 2021 by Angela Chiaravalle

Glad we could be helpful. Thanks for the feedback.

Sorry we couldn't be helpful. Your feedback will help us improve this article.

How helpful was this page?