Collection book

The collection book is the report of money that came in. It tells you how much you took in over a period and, crucially, what that money is made of: how much is principal coming back (not profit, it is your own money returning), how much is interest (that is your profit) and how much is arrears.

It is the report most used to close the day and to close the month.

Available on Gold and Premium, and an agent needs the reports:read permission. The owner always sees it.

How to use it

Go to Reports → Collections. Three controls:

• From and To. Empty = current calendar month.
• Granularity: Daily (one row per day, the usual) or Monthly (one row per month, to see the year's trend).

The totals

And it always holds: Total = Principal + Interest + Arrears.

By collector

Who brought in each peso. One row per agent, sorted by total, plus Owner / office for what you collected yourself:

To judge performance (and not just volume) use Collector performance, which also cross-references the book each one manages.

By period

The same information over time: one row per day (or per month, depending on granularity), in chronological order, with Period, Total, Principal, Interest, Arrears and Collections. This is where patterns show up: the Monday dip, the mid-month spike, the month collections fell off a cliff.

Details that prevent misreadings

• It ties out to your accounting. These figures come from the same double-entry ledger that feeds your financial statements: the report's total is exactly what entered the Cash account.
• Net of reversals. If you reversed a collection, that money no longer counts in the amounts. But the Collections column did record the original collection, so do not divide Total ÷ Collections for an "average per collection": it will lie to you.
• A collection is recognised when the instalment is completed. A partial payment that does not close the instalment does not appear yet; it will on the day it is completed.

Filter errors