Moving Allowance From a Spreadsheet to an App: Transfer the Balance Once
By Erik Nilsen · Kroni6 min read
The short version: Pick one cutoff date and review the spreadsheet up to that day. Subtract everything your child has already been paid, whether in cash, through a mobile payment app or into their own bank account. Whatever is left is what you still owe. Enter that in the app as a single opening balance with a clear note. Then lock the old spreadsheet and compare the two for the first couple of weeks.
One mistake to avoid is carrying over the full amount your child has "earned." If a lot of that money is already sitting in the piggy bank, your child suddenly gets the same money twice. Fixing that later is awkward, and someone usually ends up feeling shortchanged.
Decide what the balance means
Before you type anything in, agree on what the number in the app stands for. The simplest meaning works best:
Balance in the app = what parents have promised but not yet paid out.
Money your child already has in hand, in a piggy bank or in their own account doesn't belong in the opening balance. It has been paid, and it's theirs.
Some families would rather have the app show everything the child owns in total. That can work too, but then you need to agree that the cash in the piggy bank is only "recorded" and will not be paid out again. That version is easier to mix up, so it's a good idea to start with the meaning above. If you want to talk with your child about what a balance actually is, Balance Explained for Kids: Goals, Mastery and Money is a good place to begin.
Step 1: Reconcile the spreadsheet on a fixed date
Choose a date that's easy to remember, such as the last Sunday of the month. Everything up to and including that day belongs to the spreadsheet. Everything after it belongs to the app.
Then go through the sheet with these questions:
- What allowance was agreed up to the cutoff date?
- Which extra tasks were approved but not paid?
- What has actually been paid, and how (cash, mobile payment app, bank transfer)?
- Are there promises that never made it into the sheet, like "you'll get $5 when your room is cleaned up"?
If your child is old enough to follow along, do this review together. Then it becomes a shared number, not just the parents' number.
Filled example: Ida's three lines
Ida is a fictional 10-year-old. Her family has tracked her allowance in a spreadsheet and is switching to an app on October 1. The cutoff date is September 30. The amounts are illustrations only, not recommended rates.
| Line | What it covers | Earned | Already paid | Still owed |
|---|---|---|---|---|
| 1 | September allowance, 4 weeks at $5 | $20 | $15 (3 weeks in cash) | $5 |
| 2 | Approved extra tasks in September | $12 | $0 | $12 |
| 3 | Savings from earlier months | $70 | $70 (in the piggy bank) | $0 |
| Total | $102 | $85 | $17 |
The math is simple: $102 earned minus $85 paid leaves $17 owed.
So Ida's opening balance in the app is $17, not $102. The $70 in her piggy bank is already hers, so it doesn't get entered again.
Step 2: Enter only what's owed, once
When the number is settled, one adult enters it. Just one, so two parents don't each enter the same amount without knowing.
In Kroni, you do this from the child's page in the parent view, where you can adjust the balance manually and add a reason. There's no spreadsheet import, so you type the number in by hand. A good note might be: "Opening balance from spreadsheet as of 9/30: $17 owed. $85 already paid." Keep in mind that the app only shows virtual amounts. When you pay out real money later, you do that yourselves, with cash, a mobile payment app or a bank transfer.
A few things to watch for:
- Don't recreate every old row. You don't need to enter every week from last year. One opening balance line is enough, and the spreadsheet keeps the history.
- Savings goals aren't extra money. If Ida is saving for a bike, the goal shows how much of her balance is set aside for it. That amount is part of the $17, not added on top.
- Promises that haven't been earned yet, like a reward Ida gets when she finishes something, go in as a new task or agreement, not as balance.
Step 3: Lock the old sheet and compare the first weeks
Save a copy of the spreadsheet with the date in the file name, such as "Ida allowance through 9-30." Make it read-only, or write at the top: "Closed. New entries go in the app." That way nobody records October's allowance in two places.
For the first two weeks, do a quick check each Sunday:
- Does the opening balance still match the note?
- Have the new tasks been completed, or approved where approval is required, and did the balance go up by the right amount?
- Have you paid out any real money, and has it been subtracted in the app?
If everything lines up after two checks, you can stop looking at the old sheet.
Copyable worksheet for your own move
Copy the table and fill it in for each child. The blank fields are meant to be filled in.
Child: ______ Cutoff date: ______ Who enters it: ______
| Line | What it covers | Earned | Already paid (how) | Still owed |
|---|---|---|---|---|
| 1 | Allowance up to cutoff date | |||
| 2 | Approved extra tasks | |||
| 3 | Savings / other earned promises | |||
| Total |
Opening balance to enter (total still owed): ______
Note in the app: "Opening balance from spreadsheet as of : $ owed. $______ already paid."
Checklist:
- We agree on what the balance means
- All payments up to the cutoff date are subtracted
- The opening balance is entered once, by one adult
- The spreadsheet is saved with a date and marked as closed
- First check done (date: ______)
- Second check done (date: ______)
When several kids move at the same time
Take one child at a time, each with their own worksheet. Siblings like to compare numbers, so it helps to show each child their own calculation. Then they can see that a low opening balance doesn't mean the money is gone. It just means it has already been paid.
If you're also changing which tasks are paid, do that after the balance has moved. That keeps old and new agreements from getting mixed up. For ideas on tasks that fit your child, What should kids be able to do at home? A complete list by age is a useful starting point. Always adjust to what your own child can actually manage.
Frequently asked questions
- Should the money in the piggy bank go into the app?
- Not if the balance shows what you still owe. Money your child has already received is paid. If you enter it again, your child could end up getting the same money twice.
- Can we import the spreadsheet directly?
- No. You work out the opening balance yourselves and enter it by hand as one adjustment with a note. Keep the old spreadsheet as your history.
- What if we find a mistake after the move?
- Check the locked spreadsheet and the note on the opening balance. Fix it with one new manual adjustment and write down why. Don't edit the old sheet after the fact.
