General Ledger Reports

Derek Torres
Derek Torres
  • Updated

Important Note: PartsLedger is now PartsManager. PartsManager retains all of the parts purchasing and warehouse management automation benefits of its predecessor. To read more about this exciting change, click here.

 

In PartsManager, formerly known as PartsLedger, The General Ledger gives the starting and ending balance per ledger account for a date period, along with the activity (journal entries) during that period.

The General Ledger is split into two options: Summary or Detail.

General Ledger Summary

The Summary General Ledger Page will show the full list of Ledger Accounts with their starting balance, ending balance, and activity for the selected date range.

The Journal's Posted Date is used to determine if it is included.

PL_General Ledger Summary.png

Input Definitions

  • Start Date - Beginning date to use
  • End Date - Last date to use
  • Journal Status - Status of Journals to include (Draft, Posted, All)
  • Currency - Select the currency you want to view in this report.
  • Consolidated - Toggle on to include the activity for the selected Location in the Location Picker, and all Locations that roll up to that selected Location.
    Toggle off to only include activity for the selected Location in the Location Picker.

Expand Rows

In addition to the standard table functions, you can expand each Ledger Account row to view the Journal Entries included in the Activity column, (e.g. view the list of Journal Entries who's posted date is inside that date range).

To expand the row, click the icon:

PL_General Ledger Suma.png

General Ledger Detail

The General Ledger Detail page contains a running balance for a single ledger account.

PL_General Ledger Details.png

Input Definitions

  • Start Date - Beginning date to use
  • End Date - Last date to use
  • Ledger Account - Account to show transactions for.
  • Currency - Currency in which you hope to generate this report.
  • Journal Status - Status of Journals to include (All, Draft, Posted)

Note: The Reports are limited to 500 transactions per Ledger Account listed in the Summary or 500 transactions for the Ledger Account in the Detail. For Reports with more than 500 transactions for the date range, use the Journal Report to get the full list of transactions to excel, where you can manipulate the data to show starting and ending balances.

Was this article helpful?

/

Comments

0 comments

Please sign in to leave a comment.