Downloadable Income and Expense Worksheet for Bloggers (2024)

This article contains a downloadable income and expense worksheet for bloggers.

Hello, hello! I hope you’ve had a nice first week of 2018. 🙂 This week feels mega long to me, but we’re pushing through and looking forward to a beautiful weekend (highs in the 40s – gasp!) Besides 30 minutes in the snow on Christmas Eve, my kids haven’t played outside in over two weeks thanks to Mother Nature, and everybody could use some fresh air.

I apologize to my non-blogger readers for a super unrelatable post today, but I have some helpful info for my fellow bloggers that I wanted to share real quick. 🙂

Downloadable Income and Expense Worksheet for Bloggers

If you’re making or spending any kind of money on your site, it’s crucial that you have a way to keep track of every incoming and outgoing penny. This documentation is beneficial for a number of reasons, but at the top of that list is having records for tax season.

Jamie is an Excel wiz, so he creates me a file each year that I keep on my desktop that organizes my blogging finances. He also created a general template for me to share with you all (he’s a gem), so if you’d like this downloadable file to save right to your computer, please click here (will go straight to a download).

Downloadable Income and Expense Worksheet for Bloggers (1)

As seen in the picture above, the income portion of the template is broken down into three categories: Advertising, Affiliate, and Sponsorship. Simply plug in a number under each category, and you’ll then see it automatically inputted into the “Gross Income” column. Add an expense, and you’ll see that figure automatically deducted from your gross income in the R column. I’ve plugged in some sample numbers below for your reference.

Downloadable Income and Expense Worksheet for Bloggers (2)

Again, if you’d like to download this file straight to your computer, click here. Hope it’s helpful!

Also…

Downloadable Income and Expense Worksheet for Bloggers (3)

Would you like to be a part of this series this year?! I have openings starting in April and would love to feature you. You’d be shocked at the number of the people who reach out to be featured that let me know that they had been nervous to email me and didn’t think for a long time that their site was “good enough”. OH MY GOODNESS – I promise you are each good enough. Your site is so so so so good enough.

As a blogger, it’s hard to find new exposure authentically without paying a gazillion dollars, doing loop giveaways on IG, or doing something that feels spammy or annoying that’s not true to who you are. I know this because I struggle with it all the time. Simply put, it’s tough to find organic ways to introduce new readers to your content these days.

So in 2017 my goal was to work together to bring new exposure to each others’ blogs, and this series survived and thrived throughout the year. It was a win/win for everyone. I shared all about you (the blogger) in an personalized feature, and then you turn around and share the feature on your blog. Hooray! Everyone wins, including (especially!) the readers because they potentially find new bloggers with similar interests or who talk about topics that are applicable or of interest to them. I love building connections with the bloggers that I feature, and growing that community authentically is such a sweet side of this biz.

Ready to sign up?

Please fill out this form and I’ll get back to you with additional information in the next week or so. In the message portion, just let me know that you’re interested in being featured. THANK YOU! So excited to hear from ya. 🙂

[contact-form][contact-field label=”Name” type=”name” required=”true” /][contact-field label=”Email” type=”email” required=”true” /][contact-field label=”Website” type=”url” /][contact-field label=”Message” type=”textarea” /][/contact-form]

Downloadable Income and Expense Worksheet for Bloggers (4)

Want to check out more blogging tips? Here’s a few!

How Much Does It Cost to Run a Profitable Blog?

Downloadable Income and Expense Worksheet for Bloggers (5)

Is Your Blog User Friendly? 5 Questions to Ask Yourself

Downloadable Income and Expense Worksheet for Bloggers (6)

Making the Leap from Blogger to Self-Hosted WordPress

Downloadable Income and Expense Worksheet for Bloggers (7)

Downloadable Income and Expense Worksheet for Bloggers (8)

Erica

Hi! I’m Erica, and I absolutely adore sharing my life on this website with you! I come here almost daily to blab about all of the things related to being a regular wife and mother in today’s ever-evolving society. I share about our new home, what’s on our kitchen table, what we’re hanging in our closets, where we’re traveling to next, my crazy 5 a.m. work outs, how I make time for girlfriends, our faith, and much more. We always have a lot of balls in the air and somewhat thrive on the chaos. I believe in the power of story-telling as a form of inspiration and entertainment, so I’m here to do both! I was born and raised in north Alabama and recently re-planted roots here again after my husband transitioned out of the Army (he is now in the Reserve and it’s going so well!) I’m a super proud mom to three little girls (ages 7, 4, and 1) who seem to be the stars of the show around here (for good reason – they’re pretty great!) I’m so glad you found me and are here reading! I hope we can get to know each other here on the blog as well as Facebook and/or Instagram. xoxo

Downloadable Income and Expense Worksheet for Bloggers (2024)

FAQs

How do I make a personal income and expense spreadsheet? ›

Here are some steps that may help when building your own budget:
  1. Choose a spreadsheet program or template.
  2. Create categories for income and expense items.
  3. Set your budget period (weekly, monthly, etc.).
  4. Enter your numbers and use simple formulas to streamline calculations.
  5. Consider visual aids and other features.

How do I create a daily income and expenses sheet in Excel? ›

  1. Keeping up with your expenses doesn't have to be a tedious task. ...
  2. To enter your income, go to the "Income" sheet. ...
  3. To enter your expenses in your Excel budgeting template, go to the "Expenses" sheet. ...
  4. Let's add a budget column so that we can compare our actual expenses to our budget.
Apr 29, 2024

Does Excel have an expense report template? ›

The most effective way to create an expense report in Excel is to use a preexisting expense report template. Select an Excel expense report template from this page, and plug in your expenses for timely reimbursem*nt from your employer.

How do you make a budget and expenses spreadsheet? ›

How to create a budget spreadsheet in 7 steps
  1. Pick your platform. The best budget spreadsheet for you is probably the one you're most comfortable using. ...
  2. Break down your income. ...
  3. Break down your expenses. ...
  4. Determine timing. ...
  5. Set up the spreadsheet. ...
  6. Plug in the numbers. ...
  7. Update as necessary.
Mar 6, 2023

How do you write a personal income and expense statement? ›

Steps to Prepare an Income Statement
  1. Pick a Reporting Period. ...
  2. Generate a Trial Balance Report. ...
  3. Calculate Your Revenue. ...
  4. Determine the Cost of Goods Sold. ...
  5. Calculate the Gross Margin. ...
  6. Include Operating Expenses. ...
  7. Calculate Your Income. ...
  8. Include Income Taxes.
Feb 20, 2024

How to create an income and expense report? ›

6 Steps To Create An Expense Report: A Guide For Small Businesses
  1. Select a Template or Use an Accounting Software. ...
  2. Add or Delete Columns. ...
  3. Report Expenses as a Different Line Item. ...
  4. Calculate the Total. ...
  5. Attach Associated Receipts. ...
  6. Print or Send the Report.

How do I keep track of business expenses and income in Excel? ›

Recording daily business expenses in Excel is straightforward. Each time an expense is incurred, enter the date, description, payment method, and amount into the respective columns on your spreadsheet. It is essential to be consistent and diligent in this practice to ensure accurate and up-to-date records.

Is there a free budget template? ›

Google Sheets budget templates

The Sheets app for Drive includes pre-made templates, such as an annual budget and monthly budget. Google Sheets also provides annual business budget templates for entrepreneurs who want to track their expenses.

What is the free personal accounting software in Excel? ›

MoneyPatrol is one of the best personal accounting excel sheet free download. In addition to expense tracking and income calculation, the personal accounting Excel sheet offers sections for savings and investments.

How to make a spreadsheet for personal finances? ›

To build a budget spreadsheet, follow these steps:
  1. Choose your software and template.
  2. Calculate your income.
  3. Categorize your expenses.
  4. Decide how often to update your budget.
  5. Enter your numbers.
  6. Maintain and stick to your budget.
Jan 31, 2024

How do you track personal income and expenses? ›

Just follow these four steps.
  1. Step 1: Create a Budget. You won't be able to track expenses without one. ...
  2. Step 2: If You Make Money, Track It. When your regular paycheck comes in, enter that amount in the income part of your budget. ...
  3. Step 3: If You Spend Money, Track It. ...
  4. Step 4: Set a Regular Rhythm for Tracking.
Apr 17, 2024

How do you create an income and expenditure account? ›

Preparation of Income and Expenditure Account
  1. Include all items of revenue receipts and expenses, on the respective side of the account.
  2. Ensure that no items of capital incomes and expenses are included in this account.
  3. Also, adjustment for amounts prepaid and outstanding, with respect to each item will have to be made.

How do I create a personal income statement in Excel? ›

If you're wondering how to create an income statement in Excel these steps may help you:
  1. Create and set up the document. ...
  2. Fill in essential information. ...
  3. Create and format your column headers. ...
  4. Fill in the rows. ...
  5. Add a row for totals. ...
  6. Repeat this process for your expenses. ...
  7. Use AutoSum to calculate your totals.
Oct 24, 2022

Top Articles
Latest Posts
Article information

Author: Rob Wisoky

Last Updated:

Views: 6011

Rating: 4.8 / 5 (48 voted)

Reviews: 87% of readers found this page helpful

Author information

Name: Rob Wisoky

Birthday: 1994-09-30

Address: 5789 Michel Vista, West Domenic, OR 80464-9452

Phone: +97313824072371

Job: Education Orchestrator

Hobby: Lockpicking, Crocheting, Baton twirling, Video gaming, Jogging, Whittling, Model building

Introduction: My name is Rob Wisoky, I am a smiling, helpful, encouraging, zealous, energetic, faithful, fantastic person who loves writing and wants to share my knowledge and understanding with you.