Getting started

Moving a paper expense diary into an app

Moving a paper expense diary into an app: pick a cut-off date, enter cash lines in weekly batches, and import statements for anything that went through a bank.

Editorial illustration for Moving a paper expense diary into an app

To move a paper expense diary into an app, choose a cut-off date, enter the diary from that date in weekly batches, and import statements for everything that went through a bank or card instead of retyping it. Do not try to digitise years of handwriting. A few recent months are enough to start, and the diary's real value going forward is the cash entries it holds.

Why not retype the whole diary?

Because most of it is already on a statement. UPI payments, card swipes, EMIs, rent transfers and bill payments are all in your bank records. Typing them again is slow and invites mistakes. The diary is truly valuable only for what a bank never saw: cash, small local purchases and anything paid from someone else's account.

How do I choose the cut-off date?

  • Pick the first day of a month, so the first month is whole.
  • Go back as far as you will actually keep up with, usually two or three months.
  • If your diary runs by festival or by financial year, choose the start that makes sense for you, such as the first of April.

What is the order of work?

  1. Add your bank account and card to the tracker, and choose your base currency.
  2. Import the statements from the cut-off date to today. Review rows before saving.
  3. Go through the diary and mark each line as bank (already on a statement) or cash (needs entering).
  4. Add a cash account.
  5. Enter the cash lines in weekly batches, about ten minutes per week of diary.
  6. Do a final check against the diary's own totals, if you kept any.

What do I enter for each cash line?

Diary saysEnter asNotes
Vegetables 450, 12 OctDate 12 Oct, amount 450, note vegetables, cash accountCategory groceries or whatever you prefer
Auto 120Date from the page, amount 120, note auto, cash accountOften the same payee, so a rule helps
Milk monthly 1,800Date paid, amount 1,800, note milk, cash accountIf paid by UPI, skip it; it is on the statement
Gift 2,000Date, amount 2,000, note gift, cash accountCash or not? Check the statement

Where the diary shows a date range or a weekly total, enter one line with the nearest date and a note such as Cash, week of 6 Oct. A rough line is better than none.

A worked example with invented numbers

Say your diary for September has 62 lines. When you tick the ones that are on your bank statement, 41 turn out to be UPI or card payments. That leaves 62 - 41 = 21 cash lines to enter, probably in two batches. If the cash lines add up to ₹5,260 and your ATM withdrawal for the month was ₹6,000, then ₹740 of cash went unrecorded, which is a perfectly honest result. The numbers are made up to show the method.

What about the withdrawal itself?

The statement shows the ATM withdrawal. Your diary shows what you spent from it. Count one or the other, not both: give the withdrawal its own category and leave that category out when reading spending totals, or skip the detail. Otherwise the same cash is counted twice.

What happens to the diary afterwards?

  • Keep it. It is a record, and you may need it for a reference later.
  • Stop writing in it once the weekly routine in the app works.
  • If you like paper, carry a slip in your wallet for cash spends and enter it on Sunday.
  • Photograph any page with a receipt stuck to it; receipts can be kept with their transactions in SpendixAI.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports