Back
Categories
Back

Categories

      View All

      What is the General Ledger Report?

      The General Ledger Report shows you the details of every transaction going in and out of your accounts. These transactions are generated whenever you issue Invoices, track Expenses, accept Payments, and log Other Income to name a few.

      This goes hand in hand with the Trial Balance report, helping you ensure that all your Categories and Parent Accounts balance. You can also use the General Ledger to match your bank statement (after adjusting date range filters).

      Accounting reports like the General Ledger Report are available on the Plus and Premium plans only.

       

      The General Ledger Report will only be accurate with data from January 1, 2018 onwards.

       

      Access the General Ledger Report

      The General Ledger Report can be accessed using these steps:

      1. Click on the Reports section
      2. Select General Ledger under Accounting Reports.

       

      Settings

      To adjust your view of the General Ledger Report, click on Filters under Settings. From there, you can change: 

      Filters on the general ledger report.

      • Reset all - Click on this link to restore the filters back to the default settings
      • Date Range - Choose from This Month, This Year, Last Year, This Quarter, Last Quarter, or Custom to enter a specific date range (or if you’ve changed your Fiscal Year End date, choose from the extra options)
      • Currency - Toggle between multiple currencies
      • Limit To - Choose All Accounts, or select a specific account


      If your General Ledger has more than 5000 lines, you'll see the option to Change the filters to reduce the data set, or to Export full Report for Excel instead.

      This report is too big to view in your browser warning.


      Also, clicking More Actions in the top right will give you the option to Export your Report to Excel, or Print your Report. The Send button allows you to send the report to your accountant, or anyone else that needs to view it.

      Account Types

      The Accounts displayed are organized in the following order:

      1. Assets
      2. Liabilities
      3. Sales
      4. Expenses

      For each account, a list of transactions are displayed which make up the account’s balance. Each transaction has two corresponding entries within two accounts.

      Click on any transaction’s Account Type (highlighted in blue) to drill in to find more details on the transaction.

       

      FAQs

      What are Adjustment transactions on the General Ledger Report?

      Adjustments are also known as Journal Entries, and any Adjustments on the General Ledger Report are Journal Entries that have been created manually by your Accountant.

      You can use the below steps to filter the General Ledger Report to show all your Journal Entries in any given time period:

      1. Click on the Reports section
      2. Select General Ledger under Accounting Reports
      3. Adjust the filters as needed for the Date Range, Currency and/or Accounts you want to see, then click Apply
      4. Search for any transaction with the keyword Adjustments - these are your manually created Journal Entries
      5. To filter even further, click on the More Actions button and select Export to Excel
        1. In your spreadsheet app, you can sort by Transaction Type and filter to Adjustment transactions only. The filtered spreadsheet will now show only manually created Journal Entries with the Debit and Credit amounts for each transaction.

      Support Categories