How to Create an Income and Expense Report

Building an income and expense report is one of the most fundamental steps to understanding your business's financial health. This simple document cuts through the noise and answers the most important question: Are you making more money than you’re spending? This tutorial will walk you through exactly how to create an income and expense report, even if you’ve never touched a spreadsheet for accounting before.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly Is an Income and Expense Report?

An income and expense report, often called a profit and loss (P&L) statement, is a financial summary of your company's revenues (income) and costs (expenses) over a specific timeframe, like a month, a quarter, or a year. Its job is to calculate your net income - or net loss - by subtracting your total expenses from your total income.

Think of it as your business's report card. It tells you clearly whether your business operations are profitable. Without this report, you're essentially flying blind, making decisions based on your bank balance rather than a true understanding of your financial performance. This report is essential for:

• Budgeting and Forecasting: See where your money is going and plan for future spending.
• Decision-Making: Get the data you need to decide on pricing, hiring, or new marketing campaigns.
• Tax Preparation: Have all your income and deductible expenses neatly organized for tax season.
• Securing Loans: Lenders and investors will almost always want to see your P&L statement to assess your business’s viability.

Step 1: Gather All Your Financial Documents

Before you can build the report, you need to collect all the raw data. This is often the most time-consuming part, but good organization makes it much easier. You’ll need records for all the money that came in and all the money that went out during the period you want to analyze.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Collect Your Income Records

Track down every source of revenue. This includes:

• Sales receipts and invoices: All the invoices you sent and payments you received.
• Bank statements: Show all direct deposits, wires, and other miscellaneous income.
• Payment processor statements: Totals from platforms like Stripe, Shopify, PayPal, or Square.
• Other income: Includes things like affiliate commissions, interest earned, or asset sales.

Collect Your Expense Records

Next, gather documentation for every dollar that left your business. Keeping receipts is crucial here, not just for reporting but also for tax deductions. Look for:

• Bills and invoices from vendors: Payments for services, raw materials, or products.
• Receipts from purchases: Both digital and physical receipts for things like office supplies, software, or equipment.
• Credit card and bank statements: These will capture most of your day-to-day spending.
• Payroll records: Salaries, wages, contractor payments, and associated payroll taxes.
• Advertising invoices: Bills from Google Ads, Facebook Ads, or other marketing platforms.
• Recurring bills: Things like rent, utilities, insurance, and software subscriptions.

Pro Tip: Get in the habit of saving digital copies of all receipts in a dedicated cloud folder (like Google Drive or Dropbox) organized by month. This makes this step infinitely easier next time.

Step 2: Choose Your Reporting Tool

You don't need fancy, expensive software to create a basic income and expense report. You have a few great options, depending on your needs.

Spreadsheets (Google Sheets or Microsoft Excel)

A simple spreadsheet is the perfect place to start. It’s free (or you probably already own it), infinitely flexible, and helps you learn the fundamentals of your business finances from the ground up.

• Pros: No extra cost, completely customizable, helps you get familiar with your numbers.
• Cons: Requires manual data entry, prone to formula errors, can become unwieldy as your business grows.

Accounting Software (QuickBooks, Xero, Wave)

As your business gets more complex, dedicated accounting software becomes a lifesaver. These platforms connect directly to your bank accounts and credit cards, automatically categorizing transactions and generating professional financial reports with a few clicks.

• Pros: Automates most of the work, highly accurate, generates detailed reports instantly.
• Cons: Has a monthly subscription fee, can have a bit of a learning curve to set up correctly.

For this guide, we'll focus on the spreadsheet method, as it’s the most accessible way to learn the ropes.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Build Your Report in a Spreadsheet

Open a new spreadsheet in Google Sheets or Excel. We're going to create a simple ledger that totals up everything on its own.

1. Set Up Your Columns

Create a few columns to organize your transactions. Here’s a good starting point:

• Date: The date the transaction occurred.
• Description: A brief note about the transaction (e.g., "Client Payment - Project X," "Google Ads Spend," "Office Supply Mart").
• Category: This is a crucial column for analysis. We'll talk more about this next.
• Income: Any money coming in goes in this column.
• Expense: Any money going out goes in this column.

2. Create and Assign Categories

Categorizing every transaction tells you where your money is coming from and going to. Without categories, you just have a list of numbers. Creating categories adds context and makes your report genuinely insightful.

Common Income Categories:

• Service Revenue
• Product Sales
• Consulting Fees
• Interest Income

Common Expense Categories:

• Cost of Goods Sold (COGS): Direct costs related to selling your product (e.g., raw materials, manufacturing costs).
• Marketing & Advertising: Ad spend, promotional materials, email marketing tools.
• Salaries & Wages: Pertains to employee payroll.
• Contractors & Freelancers: Payments to non-employees.
• Rent & Utilities: Office space, electricity, internet.
• Software & Subscriptions: Monthly or annual fees for business tools (e.g., Adobe, HubSpot, G Suite).
• Office Supplies: Paper, pens, printer ink, etc.
• Bank Fees: Monthly service charges or transaction fees.
• Travel & Meals: Business-related travel and entertainment.

Be consistent! Choose your categories and stick to them. This makes comparing reports from different periods much more reliable.

3. Enter Your Transactions

Go through the financial records you gathered in Step 1 and log each transaction as a new row in your spreadsheet. For each transaction, fill in the date, a description, assign it a category, and enter the amount in either the "Income" or "Expense" column — never both.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

4. Set Up Your Summary and Formulas

Now it's time to let the spreadsheet do the work for you. At the top or bottom of your log, create a small summary section.

Calculate Total Income: In a cell labeled "Total Income," use the SUM formula to add up your entire income column. If your income values are in column D from row 2 to row 100, the formula would be:

=SUM(D2:D100)

Calculate Total Expenses: Do the same for your expenses. In a cell labeled "Total Expenses," add up the expense column. If your expenses are in column E, the formula would be:

=SUM(E2:E100)

Calculate Net Income/Loss: This is the final and most important calculation. Create a cell labeled "Net Income" and subtract your total expenses from your total income.

=[Cell with Total Income] - [Cell with Total Expenses]

If the result is positive, congratulations! Your business made a profit during this period. If it's negative, you had a net loss.

Step 4: Analyze the Report and Find Insights

Having the report is great, but the real value comes from turning the data into insights.

• Review Expense Categories: Where is the bulk of your money going? Are there any surprises? Maybe subscription software costs have crept up, or your ad spend is higher than you thought. This helps you spot opportunities to reduce costs.
• Analyze Profitability: Is your net income what you expected? If not, the report helps you figure out why. Is it a revenue problem (not enough sales) or an expense problem (spending too much)?
• Spot Trends Over Time: Once you've made a few of these reports, you can compare them month-over-month or quarter-over-quarter. Is revenue growing? Are certain expenses consistently increasing? These trends warn you of potential problems and highlight opportunities long before they become emergencies.

Final Thoughts

Building your first income and expense report demystifies your business finances, replacing guesswork with hard facts. By gathering your records, categorizing each transaction, and calculating your bottom line, you gain the clarity needed to make smarter, more confident decisions to grow your business.

As your business and its data sources grow more complex, you might find that tracking expenses and revenue is only one piece of the puzzle. Answering deeper questions, like "which of my Facebook campaigns are actually driving sales?" or "what's the ROI on my Google Ads spend?" is where manual spreadsheets break down. We built Graphed to solve this very problem. You can connect all your sales and marketing platforms, from Shopify and Google Analytics to Facebook Ads, and let AI build real-time dashboards that show you not just your profit, but exactly what’s driving it.