• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Smbiz Administrative Services
    • Brief List of Recurring Admin Services
    • Social Media Marketing and Online PPC Services
    • Bookkeeping Services
    • Account Receivable and Payable Services
    • Procedure Evaluations and Refinement Services
    • Virtual Admin Consults
    • Website Help and Maintenance Service
    • Testimonials
  • Small Business Tips
    • Administrative Support
    • Bookkeeping Tips
      • Payroll
      • QuickBooks Online Tips
    • Business Success
    • Business Gift Ideas
    • Emergency Preparedness Tips
    • Inspiration
    • Leadership
    • Marketing
      • Blogging Tips
      • Social Media Marketing
      • Website
    • Organizing
      • Computer Organization
        • Digital File Organization
      • Office Organization
      • Paper Management
      • Procedures
      • Productivity
    • Protecting Privacy
    • Small Business Owner Interview Series
  • Cookies and Policies
    • Disclosure Policies and Cookies
    • Small Business Resources Every Owner Needs
    • Write for Us
  • Home Organizing Blog
  • About Me

Sabrina's Admin Services

Marketing ~ Bookkeeping ~ Organizing

You are here: Home / Business / Organizing / Procedures / Simple Tips to Organize Your Start Up’s Invoice Process

Simple Tips to Organize Your Start Up’s Invoice Process

December 9, 2020 By Sabrina Quairoli Visit our "Disclosure Policy and Cookies" Page. Our blog earns income from ads. This post may contain affiliate links. As an Amazon Associate, I earn from qualifying purchases.

Simple tips to organize your start up invoice process

I was working with a client to set up an invoice system to speed up the invoice process she needed to do each month. She dreaded it so much.  She would procrastinate for days. This client has about 15 recurring clients to bill random work hours at different rates from the previous month.  To do the invoice process, she would write all her invoices by hand, then write the envelope. It would take her hours, maybe even days, to do all the invoices.

We had an initial meeting, and I watched as she did her invoices for the previous month.  She wasn’t computer savvy and didn’t want to use QuickBooks for this process.  So, I helped her determine another system that would work best for her abilities. She does use a phone and a tablet. Below are simple tips for organizing hers and your startup invoice process if you are not computer savvy.

Simple Tips To Organize Your Invoice System

Step 1: Create a spreadsheet list of all your clients.

We first created a spreadsheet list of all her clients and all their individual contact information.  This process took some time since it never was done before.  It was needed to make the labels and set up email marketing mailing lists for her to use. This list was able to be used and merged to create labels and invoices using the merge feature in Microsoft Word.

Step 2: Create a place to track the hours spent on each client.

Before starting to invoice, she needed to tabulate all the hours for each client and put it on a list.  She wrote information about her clients’ names, the total hours, overall visits, etc… This step would help the invoicing process go more smoothly.

Step 3: Create an electronic version of the invoice on your computer or phone using a word processing app.

We set up an electronic version of her invoice on the computer so she could re-use the page over and over for invoicing and did not have to write in any comments specifically for each customer because she had added it the first time for the customer. This invoice template was set up in a Microsoft Word document. We used tables in the invoice for her to write information. It worked out nicely because it kept all the content organized. Each client had their own invoice client number – and we added the month number and year to the filename. For example, we labeled John Smith’s invoice “Jsmith-01-2020” for January 2020 invoice.

TIP: You can also use Google Docs or Apple Pages to make the template for your invoice. It will be backed up to your cloud for easy retrieval.

Step 4: Create an invoice log.

We set up an invoice log file that tracked all the invoices that were sent out to the clients.  This log included columns like invoice number, description of the invoice, the amount invoiced, date of invoice, date paid, and check number.  

Tip: Add a formula to the right side of the amount due invoice for the last invoice for a particular month to get monthly invoicing totals.  A formula like =sum(b2…b15)  (=sum(b#(the first invoice column and row for that specific month)…b#(the last invoice column and row for that particular month.)) 

By adding this formula, she will be able to see how much money is coming in monthly. There are other formulas you can use as well, check out your spreadsheet software under formulas.

Step 5: For invoices that need mailing, make full sheet address labels for each client.

We then generated full sheet labels for recurring clients, so she didn’t need to write any of the envelopes. We used the client spreadsheet (we had set up initially). Set up a mail merge to sheets of labels and printed them out.

If you have clients who want emailed invoices, add each client’s email address and full name to your address book through your email provider application. When you need to send the email, you can add the first few letters, and it will appear in the “To” section. Then, add the invoice as an attachment to the email.

Step 6: If you use Google Drive, iCloud, or OneDrive, you can use the Google Sheets, Apple Numbers, or Microsoft Excel apps on your phone or tablet to store the invoices.

If you have an android phone, you probably have a Google Drive. Just download the Google Sheets and start creating this spreadsheet as stated above. You can do the same thing if you have Microsoft 365 or iOS (Apple). It will automatically back up the spreadsheet for you to use later on your other devices.

Step 7: When the invoices are paid, update the Spreadsheet with the check number and date paid.

When you receive payment, you can go back into the spreadsheet and add the paid date and amount paid so you can see who has not been paid yet. That’s it.

That’s it! After modifying her invoice system, it now takes her 50% less time to write-up the invoices, track paid invoices, and file invoices away. She was happy with the new system.

I hope this post helps you get your business invoices process started. As you get more comfortable with the invoicing process, you can modify it or even change it to an online app like QuickBooks Online or FreshBooks. The spreadsheet can be converted into these applications.

If you have any questions, please leave them below and I will be sure to get back to you soon.

If you need help with your invoice process, please contact me.

I found additional articles online about the invoicing process. Click the links below.

Simple Invoicing Upgrades For Small Businesses

8 Tips for Setting Up a Killer Invoicing System That Always Gets You Paid

Please note these are affiliate links through Amazon, and at no additional cost to you, I will earn affiliate fees if you decide to make a purchase.

Simple tips to organize your start up invoice process
Simple Tips to Organize Your Invoice Process
(Visited 8,003 times, 29 visits today)

Filed Under: Bookkeeping Tips, Procedures Tagged With: accounts receivable tips, invoicing, setting up a invoice system, simple invoice systems for startups, Tips

About Sabrina Quairoli

I love to help small business owners make their work and home life more organized and effective to speed up actions and minimize costs. I own and write for Sabrina's Admin Services and Sabrina's Organizing Blogs.

Primary Sidebar

Having issues keeping your Digital and Physical Files Systems Organized? Get our FREE ebook!

Sign Up for The Best Practices for Digital and Physical Filing Systems Free ebook

Looking for tips on a particular topic? Write the keyword here.

Looking for Specific Sm Biz Admin Tips?

Visit our services list to help your business!

Sabrina's Admin Services Helping Take the busy out of your day

Want to receive the Admin Newsletter and blog updates? You Get 15 checklists, plus the free ebook!

Subscribe to our mailing list

* indicates required
Small Business Owners

Amazon Disclosure

Sabrina’s Admin Services blog is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

VISIT OUR MOST POPULAR SMALL BUSINESS POSTS

  • 6 Tips for Keeping Effective Filing Systems in the Office
  • Important Tips to Organize Office Files – So…
  • How To Remember Tasks At Work
  • Small Business Microsoft OneNote Notebook Tips
  • 8 Important Documents Every Small Business Owner…
  • Simple Tips to Organize Your Start Up’s Invoice Process
  • How To Make Your Budget More Effective
  • How to Create a Well-Organized Small Business…
  • 8 Important Examples of Small Business Paperwork Systems
  • How To Organize Employee Records in Your Small Business

Have You Visited Our Home Life Organizing Blog Today?

Sabrina's Organizing Blog

Customized Google Search from Sabrina’s Admin Services and other experts



Shop Calendars.com Now!
Grammarly Writing Support

Footer

Welcome! Thanks for stopping by my blog.

I love to help small business owners make their work and home life more organized and effective to speed up actions and minimize costs. I own and write for Sabrina's Admin Services and Sabrina's Organizing Blogs. Feel free to read more about me...

  • Disclosure Policies and Cookies
  • About Me
  • Write for Us

Membership and Blogger Groups

Official PayPal Seal


Featured on Hometalk.com Professional Organizers Blog Carnival

Engage with Us on Social Media

  • Bloglovin
  • Facebook
  • Instagram
  • LinkedIn
  • Pinterest
  • RSS
  • Twitter
  • YouTube

Google Chrome Privacy Statement and Opt-Out Option

To better serve our visitors, our site collects visitors’ activities on our site. We only use this data for making our content better and more relevant to our visitors. If you wish to opt-out of us collecting your information, please click on this link.

Copyright © 2021 · Sabrina's Admin Services Blog and website content by Sabrina Morresi-Quairoli is licensed under a Creative Commons Attribution-NoDerivs 3.0 Unported License. Based on a work at Sabrina’s Admin Services blog, website, and newsletters. Permissions beyond the scope of this license may be available at contact page