Custom Report Examples

25

In a double entry accounting system, all transactions are recorded in the general ledger twice. Each component being in a specific account in the general ledge, and the account has specific features. Possibilities include (but Lubos could expose others):

  • Profit and loss Account
  • Cash at bank
  • Cash on hand
  • Accounts receivable
  • Accounts payable
  • Inventory on hand
  • Employee clearing account
  • Control account for capital account
  • Control account for special account
  • Control account for fix Assets
  • Control account for fix Assets Accumulated Depreciation
  • Control Account for intangible assets
  • Control Account for intangible assets Accumulated Amortization
  • Has customers

For each half of the double entry in the general ledger each of the above conditions will be true or false. Manager’s custom report generator has the ability to test for each of these conditions. For example if you are looking for something which is in the profit and loss section then use the test
Where IsProfitAndLoss is Checked

Conversely if your are looking for general ledge entries from the Balance sheet side use the test
Where IsProfitAndLoss is Not Checked

Other characteristics of the transaction can be tested by other “Where…” tests. For example in a report about your customers, try starting with
Where... Customer is not empty
Sort... By Customer
Group ... By Customer
Will produce a list of all transactions for each customer. Filter this list further to display the specific feature you want to extract for this customer report.

The same approach can be used for Supplier, Payer, Employee, Inventory items, Inventory kit, Inventory location, Non inventory item, etc.

You are correct though, it does take some experimenting to get what you want, which is why it is best to

  1. Initially Select (show) more fields (data) than you will need in the final report
  2. Experiment with filtering (Where…) to get just the entries you want
  3. Then delete the fields (shown as columns) you do not need to show in the final report
  4. And collapse fields only after you have checked you have actually found what you want to find.

Edit
Updated list of General ledger account tests currently available

1 Like