Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Money · Advice & Questions ·

My budget counted the groceries and the card repayment. Have I spent the same $80 twice?

Money category photographMoney

My monthly summary says $160 spent, but I can only find one $80 grocery shop. I bought it on a credit card, then repaid the full $80 from checking. The sheet imported both transactions into the spending total.

There are no other purchases, fees, interest or earlier card balances in this simplified example. Both records are real entries in the sheet, but only one basket of groceries came home.

I want to track what I bought and keep enough checking money for the payment date. How would you organize those two views without deleting a useful record or counting the same purchase twice?

Discussion

5 community replies

Choose what the spending summary is meant to show. For the cost of groceries, the purchase is $80. Keep the repayment record, but give it a treatment that doesn't add another grocery purchase.

The checking view still needs the $80 leaving on the repayment date. Correcting the spending total shouldn't make the upcoming bank payment disappear from your plan.

Reconcile the starting card balance, purchase, payment and ending balance in this example: zero, plus $80, minus $80, back to zero. That is a useful check before changing your import categories.

A simple rule could be to count only money leaving checking. Wouldn't that avoid duplicate spending altogether?

It would track a cash movement, but could place this month's groceries in a later month if you repay later. Decide whether that timing serves your purpose. You can maintain a cash calendar and a purchase summary instead of forcing one number to answer both questions.

Join the discussion

More in Money