Skip to main content

Cash Receipt Book: Step-by-Step Guide

Updated over 2 months ago

Overview

The Cash Receipt Book (shown in the app as Cash Receipts Journal) is part of Financials → Books of Original Entry. It lists all cash received for a selected date range and location, formatted in a BIR-aligned cash book layout with export-ready totals.

On screen you’ll see:

  • A title and short description (“Generate BIR-aligned ledgers, journals, and cash books with export-ready totals.”)

  • Filters for dates and location

  • A Refresh button to load the report

  • Download buttons for CSV and PDF

  • A table listing each cash receipt with a totals row at the bottom

This module uses the path:

/dashboard/accounting-reports/philippines/cash-receipt-book

and sits alongside:

  • General Journal

  • Sales Journal

  • Purchase Journal

  • Cash Disbursements Journal

  • General Ledger

You can move between these reports using the tabs at the top of the page.


Key Features

1. BIR-aligned cash receipts view

  • Shows each cash receipt with the following details: Date, Reference Type, Reference #, Received From, Description, Account Code, Account Name, Debit, Credit.

2. Date range filter

  • Uses a date picker where you choose a start date and end date.

  • If the start date is later than the end date, the page shows an “Invalid date range” warning telling you that the start date must be on or before the end date.

3. Location filter

  • A Location dropdown lets you run the report for All locations or for a specific location.

4. Refresh button

  • The Refresh button reloads the report with the currently selected date range and location.

  • It is disabled while the report is loading or when the date range is invalid.

5. Totals row

  • When there are entries, a Totals row appears at the bottom of the table, showing the summed Debit and Credit amounts.

6. CSV and PDF export

  • CSV export uses column headers that match the on-screen table, including “Received From” for the cash receipts view, and adds a totals row with summed debits and credits.

  • The CSV/PDF title includes “Philippines Cash Receipt Book”, the selected location, and the date period.

  • The Download CSV and Download PDF buttons are shown next to the Refresh button.

7. Clear messages when there is no data or an error

  • If there are no cash receipts for the chosen period, the table shows:
    “No cash receipts for this range.”

  • If the system cannot load the report, an error box appears with “Unable to load report” and a suggestion to adjust filters or try again later.


Getting Started

Step 1 – Open the Cash Receipt Book

  1. Sign in to your DizLog account.

  2. In the left menu, go to Financials.

  3. Under Books of Original Entry, choose Cash Receipt Book (labelled Cash Receipts Journal in the page tabs). The route for this tab is /dashboard/accounting-reports/philippines/cash-receipt-book.

You’ll see:

  • The page title “Cash Receipts Journal” and a short explanation under it.

  • Tabs for other Books of Original Entry reports (General Journal, Sales Journal, Purchase Journal, Cash Disbursements Journal, General Ledger).

Step 2 – Check your date range

By default, a start and end date are filled in for you.

  • If needed, click the date pickers and choose the period you want to review.

  • Make sure the start date is not later than the end date; otherwise, you’ll see the invalid date range warning and the report will not load.

Step 3 – Choose a location

  • In the Location dropdown, select All or a specific location.

  • When “All” is selected, the report treats it as “All locations”.


How to Use

1. Run the Cash Receipt Book report

  1. Set your date range.

  2. Select the Location (or keep it at “All”).

  3. Click Refresh to load the report.

  4. While loading, a spinner appears; the button is disabled until loading is complete.

2. Read the table

Once the report loads, you will see a table like this:

  • Date – when the receipt was recorded.

  • Reference Type – the type of transaction or source document.

  • Reference # – the identifying number (e.g., document or transaction number).

  • Received From – who paid you (this column label switches to “Paid To” in the Cash Disbursement Book tab).

  • Description – short text describing the receipt.

  • Account Code and Account Name – which account in your chart of accounts the receipt is posted to.

  • Debit and Credit – the amounts posted to each side of the entry, shown with two decimal places.

At the bottom of the table, a Totals row adds up the debit and credit columns for all listed receipts.

If there are no cash receipts in your chosen period and location, you’ll see a single row telling you that there are no cash receipts for this range.

3. Export the report

You can export the same data you see on screen.

Export to CSV

  1. After loading the report, click the CSV icon or button next to Refresh.

  2. The file includes:

    • Columns for Date, Reference Type, Reference Number, Received From, Description, Account Code, Account Name, Debit, Credit.

    • One row per cash receipt.

    • A final row with “Totals” in the Reference Type column (CSV only) and summed Debit and Credit values.

  3. The exported file name follows the pattern cash-receipt-book-philippines-<start> – <end>.csv.

Export to PDF

  1. Click the PDF icon or button next to the CSV button.

  2. The PDF uses the same title information as the CSV (for this tab: “Philippines Cash Receipt Book”, location, and period).

  3. The PDF captures the visible report section identified by the internal report container, so it matches what you see on screen.

4. Switch to related modules

From the tab bar at the top, you can move to related Books of Original Entry reports without leaving the page:

  • General Journal – all journal entries.

  • Sales Journal – sales transactions.

  • Purchase Journal – purchase transactions.

  • Cash Disbursements Journal – cash payments (the “Paid To” view uses the same layout as the Cash Receipt Book but for outgoing cash).

  • General Ledger – per-account running balances.

These modules all share the same date and location filter pattern and use the same export controls.


Troubleshooting

1. “Invalid date range” message

What you see:

A yellow box with the title “Invalid date range” and the message that the start date must be on or before the end date.

What to do:

  1. Open the date picker.

  2. Make sure the start date is earlier than or equal to the end date.

  3. Click Refresh again.

2. “Unable to load report”

What you see:

A red box with “Unable to load report” and a note to adjust filters or try again.

What to do:

  1. Check that your date range is valid.

  2. Try another location (for example, All).

  3. Click Refresh again.

  4. If the issue continues, try reloading the page and running the report again later.

3. No rows – “No cash receipts for this range.”

What you see:

A single table row with a grey message that there are no cash receipts for this range.

What to do:

  • Confirm that there are actually cash receipt transactions in the system for the chosen dates and location.

  • Try widening the date range or selecting All locations, then click Refresh.

4. CSV or PDF won’t download

What you see:

  • Clicking the CSV or PDF buttons doesn’t seem to save a file.

What to do:

  1. Make sure the report has loaded (there should be no loading spinner and no error message).

  2. Click Refresh, then try the export button again so the latest data is used.

  3. Check your browser’s downloads area or ask your IT administrator if downloads are being blocked.


Using the Cash Receipt Book this way lets you quickly review and export all incoming cash for any period and location, while staying aligned with the other Books of Original Entry modules in DizLog.

Did this answer your question?