Shop account book: what came in, what went out, and the balance after every line.
Write each movement of money on a line: date and description, what came in as cash, what came in by card or transfer, what went out, then pick the category from the list. The book computes the balance after every line and the totals at the bottom, and on the second sheet you type the first day of a month to see in, out and net for each category. It differs from the daily close because it covers all of the shop's money, not only the drawer, and from the expense log because it holds the money coming in as well.
Download
English
العربية
کوردی
Plain files with no macros; they work in Excel, Google Sheets and LibreOffice.
| In (cash) | What went into the drawer: cash sales and collections. |
|---|---|
| In (card/transfer) | What went to the bank account without passing through the drawer. |
| Category | A drop-down with eleven categories; the monthly summary groups by it. |
| Running balance | Everything in − everything out up to this line; do not type it. |
When the sheet stops being enough
The book believes what you type, and a line you forget never shows. In Dashing there is no book to keep: every sale, expense and payment is recorded where it happens, and the income statement, balance sheet and aging reports are computed from them.
Common questions
How do I start the book with money already in hand?
Make the first line the "Opening balance" category and put the amount under In (cash) or In (card/transfer). The balance starts from it, and it shows in the monthly summary if its date falls in the chosen month.
Why does an amount not show in the monthly summary?
Usually because the line has no category, a category typed differently from the list, or a date outside the month at the top of the summary. Pick the category from the list and enter the date as a real date.
How many lines does the book hold?
300 lines come ready with formulas, enough for a month in a small shop. For a new month, save a fresh copy of the file and start with an Opening balance line from the last balance.