Spreadsheets

Opening balances when you move from a sheet to an app

Moving from a spreadsheet to an expense app? Pick a cut-over date, note each account's balance from the statement and check it after the first import.

Editorial illustration for Opening balances when you move from a sheet to an app

Pick a cut-over date, read each account's balance on that date from the bank or card statement, and record it as your starting point. After your first import, check that opening balance plus credits minus debits matches the next statement's closing figure. If it does, the app and your bank agree and you can retire the old sheet.

Which cut-over date should you pick?

Choose a clean boundary, such as the first of a month or the first of April if you think in financial years. A date in the middle of a month works but means cutting a statement in half. Whatever you pick, the rule is the same: the sheet owns everything before it and the app owns everything on or after it. Nothing should be in both.

What do you need to note on that date?

Account typeWhat to read from the statementWatch out for
Savings or current accountClosing balance at the end of the day before the cut-overUse the statement, not the app or passbook balance, which may include pending items
Credit cardTotal amount owed at the end of the day beforeThis is money you owe, so note it as owed, not as a positive balance
WalletBalance shown in the walletScreenshot it with the date
Cash in handA physical countCount it on the cut-over date, not from memory

How do you check the starting point is right?

Say your savings account closed March at ₹1,24,300. In April the statement shows credits of ₹85,000 and debits of ₹71,250. Then 1,24,300 + 85,000 = ₹2,09,300, and 2,09,300 - 71,250 = ₹1,38,050. If the April statement closes at ₹1,38,050, the first import is complete and nothing is missing or doubled.

If the statement says ₹1,38,500, you are ₹450 short somewhere. Look for a missed row of that amount, a row that failed to import or an amount that was read wrongly. Fix it now, while the month is small.

What if the app has no opening balance field?

Check how your chosen tracker treats balances before you rely on one. Some trackers hold a starting balance, others only sum the transactions you load. If it does not hold one, keep the figure in your own notes with the date and bank, and compare against the statement's running balance after each import instead. The check is the same; only the place the number lives changes.

In SpendixAI you pick the account (bank, card or wallet) before importing, and each transaction keeps that account, so you can read activity account by account and compare it with the matching statement. Choose the base currency before your first import, because it cannot be changed once transactions exist.

A cut-over in five steps

  1. Finish the old sheet up to the day before the cut-over and take a copy marked Archive.
  2. Write down each account's balance on that date, with the statement name next to it.
  3. Upload each account's statement from the cut-over date onwards, one account at a time, and review the rows before saving.
  4. Run the opening plus credits minus debits check for each account.
  5. Note any difference, fix it and only then stop updating the old sheet.

What about credit cards and cash?

A card's balance is what you owe, so a starting amount of ₹18,400 owed means the first card bill after the cut-over includes ₹18,400 of old purchases that you already recorded in the sheet. Treat the payment of that bill as clearing the old amount, not as fresh spending. Cash has no statement, so count it on the day and note the figure. From then on, record cash expenses as they happen, and check the count against your records every so often.

Before you retire the sheet

  • Every account has an agreed starting figure.
  • Each account matched its first statement after import.
  • The archive sheet is saved somewhere you will find it in a year, because you may need it for old bills and for your CA.
SPENDIXAI JOURNAL

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

Explore your reports