Business

Monthly expense report PDF: what to include for a joint review

What a monthly expense report for two people should contain, a worked example in rupees, and how to turn a sheet into a clean PDF you can review together.

Editorial illustration for Monthly expense report PDF: what to include for a joint review

A monthly report that a partner will actually read fits on one or two pages and answers four things: what came in, where it went, what changed since last month, and what needs a decision. Build it from your category totals, then save it as a PDF from your spreadsheet so both of you see the same thing.

What goes on the page?

  1. Income for the month, listed by source, so the starting point is not a guess.
  2. Spending by category, largest first, with the rupee amount beside each.
  3. Comparison with last month for the five or six categories that moved most.
  4. Fixed commitments: rent, EMIs, insurance, school fees and any yearly payments coming up.
  5. What is left, and where it went: savings, a joint account, or carried over.
  6. Two or three notes for discussion, written as questions rather than blame.

A worked example with made-up numbers

Say a couple has a combined take-home of ₹1,10,000. Their category totals for the month are:

CategoryAmount in rupees
Rent28,000
Groceries14,500
Utilities and internet5,200
Transport6,300
Eating out7,800
Shopping9,100
EMI15,000
Other4,100
Total spending90,000

Income minus spending is 1,10,000 minus 90,000, which leaves ₹20,000 for savings or a shared goal. If last month's eating out was ₹5,900, then this month it rose by ₹1,900 (7,800 minus 5,900), and that line becomes the first discussion point. A page like this takes five minutes to read and ends with a decision, not an argument.

How do you make the PDF?

Keep the layout simple: a title with the month, a totals table, one chart if you like, and a short notes box. In Excel, use the Save As or Export option and choose PDF. In Google Sheets, use File, then Download, then PDF, and pick the print range and page orientation first. Check the preview for cut-off columns before you send it to anyone.

Should the report be the same every month?

Yes. Using the same layout lets you compare months by eye. Change only the numbers and the three notes. If you add a new category, add it to the list and mention it once so the totals still reconcile with last month.

What about a couple who each have separate accounts?

  • Make one report per person for personal money and one for shared costs.
  • Agree what counts as shared: rent, groceries, utilities, a trip.
  • Show the shared total at the top of both reports so nobody has to add it again.
  • Leave personal categories at the level of detail the person is comfortable with.

Where does the data come from?

Most of the effort is pulling numbers together. SpendixAI lets you upload bank or card statements as PDF, CSV or Excel, review the rows before saving, add cash by hand, and then see spending by category. The reports section includes a Report builder and a CSV download, so you can take the totals into your own sheet and format the page the way you like. Check which download options your plan includes before relying on a ready-made PDF.

A one minute checklist before you share

  • Do the category totals add up to the total at the bottom?
  • Is this month's comparison against the right month?
  • Have both people's cash spends been added?
  • Is there anything on the page you would not want read aloud at dinner?
  • Is the file named with the month, so you can find it again?
SPENDIXAI JOURNAL

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

Explore your reports