Back
Back
Categories

What is the General Ledger report?

The General Ledger report displays details of every transaction going in and out of your accounts on an accrual basis. These transactions are generated from your activity in FreshBooks, including sending invoices, tracking expenses, accepting payments, logging other income, and more.

This works alongside 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.

 

The updated General Ledger report is only available to trials and new accounts created as of September 13, 2024 currently. Our product team is working on making the updated General Ledger report available on Plus, Premium, and Select plans in the near future.

If you’re interested in trying the updated General Ledger report, sign up for the waitlist.

 

 

Access the General Ledger Report

The General Ledger report can be accessed using these steps:

  1. Select the Reports section
  2. Then select General Ledger under Accounting Reports.

 

Updated General Ledger Report

The updated General Ledger report is only available to specific users currently. Our product team is working on making the updated General Ledger report available to Plus, Premium, and Select plans in the near future.

If you’re interested in trying the updated General Ledger report, sign up for the waitlist.

 

To adjust your view of the updated General Ledger report, select either of the following:
General ledger report with filters displayed.

  • Quick Filters - Select either This Month, Last Quarter, or Last Year
  • Filter
    • Date Range - Choose from This Month, Last Month, This Quarter, Last Quarter, This Year, Last Year, All Time, or Custom
    • Accounts - Choose from All Accounts or select a specific account
    • Currency - Toggle between multiple currencies, only one currency can be viewed at a time
  • Columns - Choose which columns to show or hide on the General Ledger report:
    • Default
      • Select All
      • Date
      • Transaction Type
      • Transaction Number
      • Amount
      • Balance
    • Additional
      • Select All
      • Account Type
      • Account Subtype
      • Account Number
      • Client
      • Vendor
      • Project
      • Note
      • Related Account
      • Debit
      • Credit
      • Currency
      • Matched

 

Additional options can also be accessed by selecting the More Actions button in the top right corner of the updated General Ledger report:

  • Download CSV - Download the report as a CSV file
  • Print or Save PDF - Print the report or save the report as a PDF using the print dialog

 

Account Types

The accounts displayed are organized in the following order:

  1. Asset
  2. Liability
  3. Equity
  4. Income
  5. Expense

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

Select any transaction’s Account Type, highlighted in blue, to drill in and find more details on the transaction.

For more information on the Retained Earnings account, use the Balance Sheet report instead.

 

FAQs

What are journal entry transactions on the General Ledger Report?

Journal Entries (previously known as Adjustments) are journal entries that have been created manually by your accountant or by you through Advanced Accounting.

You can run a Journal Entry report to view all manually created journal entries, or you can use the below steps to filter the General Ledger report to show all your journal entries in any given time period:

  1. Select 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 view, then select Apply
  4. Search for any transaction with the keyword Journal Entry - these are your manually created Journal Entries
  5. To filter even further, select the More Actions button and select Export to Excel
    1. In your spreadsheet app, you can sort by Transaction Type and filter to Journal Entry transactions only. The filtered spreadsheet will now show only manually created Journal Entries with the Debit and Credit amounts for each transaction.

 

General Ledger Report

Accounting reports like the General Ledger report are only available on Plus, Premium, and Select plans.

 

To adjust your view of the General Ledger report, select Filters under Settings. From there, you can change: 
Filters on the general ledger report.

  • Reset all - Select 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, only one currency can be viewed at a time
  • Limit To - Choose All Accounts, or select a specific account


If your General Ledger has more than 5000 lines, you'll find 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.

 

Additional options can also be accessed in the top right corner of the General Ledger report:

  • More Actions
    • Export for Excel - Download the report as a CSV file
    • Print - Print the report or save the report as a PDF using the print dialog
  • Send... - Email the report to any specific email addresses

 

Account Types

The accounts displayed are organized in the following order:

  1. Asset
  2. Liability
  3. Equity
  4. Income
  5. Expense

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

Select any transaction’s Account Type, highlighted in blue, to drill in and find more details on the transaction.

For more information on the Retained Earnings account, use the Balance Sheet report instead.

 

FAQs

What are journal entry transactions on the General Ledger Report?

Journal Entries (previously known as Adjustments) are journal entries that have been created manually by your accountant or by you through Advanced Accounting.

You can run a Journal Entry report to view all manually created journal entries, or you can use the below steps to filter the General Ledger report to show all your journal entries in any given time period:

  1. Select 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 view, then select Apply
  4. Search for any transaction with the keyword Journal Entry - these are your manually created Journal Entries
  5. To filter even further, select the More Actions button and select Export to Excel
    1. In your spreadsheet app, you can sort by Transaction Type and filter to Journal Entry transactions only. The filtered spreadsheet will now show only manually created Journal Entries with the Debit and Credit amounts for each transaction.

Support Categories