GL Posting

This is a Club Prophet Executive Report v4 – Power BI or PBI Power Business Intelligence – a reporting tool from Microsoft..

Note: Samples are using demo data and do not reflect real-world data.

GL Posting Report

The GL Posting report shows a total of Debits and Credits from Transactions by General Ledger Code (GL Code).  This is typically used to do manual General Journal entries into your accounting package if you are not using one of the available accounting Interfaces available from Club Prophet.

• Group = Group for the General Ledger Account (Payment, Revenue, Inventory, Tax, etc).

• GL Code = General Ledger Account Number.

• Debit = Total amount to Debit to the GL Account for the given filters.

• Credit = Total amount to Credit to the GL Account for the given filters.

• Total = Credit – Debit.

FILTERS

There are various filters you can use to narrow down the data.  Filters are the gold background controls as well as the Filters right hand sidebar.

Tips

• Filters which are the gold back color controls on the report allow you to pick from a list.  Hold down the Ctrl key on the keyboard to select multiple items.
• If you want to search for a particular value, use the filters in the right pane menu.  They will have a search box in addition to a list of the items.
• Use the Advanced option in the right menu panel for advanced search options.
• Use the three dots […] in the top right of a visual for more options like Export data.

• Use the Help button to open the user guide for any given report .