Rawal Book Centre

Daily cash closing & online collections

Date & Opening Balance

Closing Date

Opening Cash (carried forward)

Accountant (prepared by)

Sales every sale — cash, online or credit

Method	Account / Person	Customer / Comment	Amount

No sale entries yet.

Payments Received collections from customers

Method	Account / Person	Customer / Comment	Amount

No payment entries yet.

Expenses

Expense	Note	Amount

No expenses yet.

1. Drawer report (cash only)

B/F (opening cash)0

+ Cash sales0

+ Cash payments received0

= Total cash0

− Expenses0

Cash in Drawer

count the drawer — it should be exactly this

Cash collected from the drawer by

Amount collected (Rs)

Cash Left for Next Day

cash in drawer − cash collected — becomes tomorrow's B/F

2. Total report (all money)

Cash sales0

Online sales0

= Total sales0

Cash payments received0

Online payments received0

Tour cash (kept by employee)0

= Total payments0

= Total cash flow (sales + payments)0

− Expenses0

+ B/F (opening cash)0

Total Closing

B/F + cash flow − expenses

Where the total closing is

Cash in drawer (from report 1)0

Online in accounts0

Tour cash with employees (not at shop)0

Total received today (cash collected + online + tour cash)0

Saving locks the day. After that only an admin can change it.

Change history for this day

Daily Closing Report

Pick a date range.

Saved days

Tap a day to open it

Users & access

Create logins for accountants / staff and choose what each one can use

+ Add user

Logins without access

People

Accountants, cash collectors, tour staff & account holders

Bank & wallet accounts

Expense names

Account types

Bank, mobile wallet, …

WhatsApp sharing

Where "Share on WhatsApp" sends the daily closing

Leave empty to choose the chat or group each time.

Payment methods

What appears in the Method dropdowns

Ask who received it

To leave tour cash out of the closing cash, use a method set to "Cash kept by a person". To count it in the drawer, set it to "Cash — goes into the shop drawer" and tick "Ask who received it". Changes apply to new entries; saved days keep what they were saved with.

Customers

Import schools / customers from Excel

Upload your list (.xlsx, .xls or .csv). You'll see a preview before anything is added; names already in the list are skipped.

📥 Upload Excel file

Bulk add

PDF

Backup

Download a copy of everything — closings, change history, people, accounts, customers and settings. Take one every day and keep it in Google Drive, email or a USB.

Restore from backup…

The Excel backup opens in Excel or Google Sheets (first sheet: one row per day) and can also be restored into the app. Don't rename its sheets or column headings, or it can't be restored. Older .json backups can still be restored.

Recovery kit = everything needed to rebuild the whole system if the website or Firebase is lost: the data backup, the app files, the security rules, the users list and step-by-step RECOVERY.txt. Make one weekly and keep it in Google Drive and email.

Cash chain check

Recalculates every day's opening cash from the day before it (days where an admin set the opening cash by hand are kept). To change a day's cash forwarded, open that day and edit "Amount Actually Collected" or its opening cash.