• Home

  • Automation with Zapier

  • Automation inspiration

Automation inspiration

3 min read

5 simple ways to automate bookkeeping

Track expenses, upload receipts, connect accounts, and more

By Lauren Myers · May 4, 2021
A dollar sign in a white box on a light orange background.

If you only think about bookkeeping when it's time to reconcile your budget or file your taxes, it probably causes a lot of dread. You have to wrangle receipts, transactions, and write-offs. And if you're not the best at staying on top of this work, it makes it worse, since you have to go back through your records to find anything that's missing. 

Here are five ways you can streamline and automate the process so when it's time to go over your budget, you're ready and can face this task with more peace and less dread.

Use an accounting app

The first and easiest way to streamline your bookkeeping is by using an accounting app to keep track of income, expenses, invoice status, and quarterly and annual taxes. You need a place to house all your transactions so it's easier to file your Schedule C or other business tax forms. 

When you use an accounting app, the values on these forms are automatically calculated from the transactions that were added to the app, so this eliminates the need to make these calculations yourself.

There are many apps to choose from such as QuickBooks, FreshBooks, Xero and Expensify—and many of the best integrate with Zapier so you can automate many of your bookkeeping tasks. 

Choosing accounting software comes down to personal preference, but we've put in a lot of research. Get started by reviewing our recommendations for the best overall accounting software.

Connect your payment processors to your accounting app.

One helpful way to automate your income transactions is by linking your payment processor accounts to your accounting app. For example, if you use Stripe or PayPal to receive credit and debit card or check payments, by connecting these apps using a built-in integration or Zapier, you can track income automatically.

Add sales receipts in QuickBooks Online for PayPal sales

Add sales receipts in QuickBooks Online for PayPal sales
  • PayPal logo
  • QuickBooks Online logo
PayPal + QuickBooks Online

Create QuickBooks Online customers with sales receipts for new Stripe payments

Create QuickBooks Online customers with sales receipts for new Stripe payments
  • Stripe logo
  • QuickBooks Online logo
Stripe + QuickBooks Online

Add new Stripe charges to FreshBooks New as payments

Add new Stripe charges to FreshBooks New as payments
  • Stripe logo
  • FreshBooks logo
Stripe + FreshBooks

You can also track sales in Google Sheets, Excel, or Airtable:

Add rows to Google Sheets spreadsheets for new PayPal sales

Add rows to Google Sheets spreadsheets for new PayPal sales
  • PayPal logo
  • Google Sheets logo
PayPal + Google Sheets

Add new PayPal sales to Excel spreadsheets

Add new PayPal sales to Excel spreadsheets
  • PayPal logo
  • Microsoft Excel logo
PayPal + Microsoft Excel

Create Airtable records for new successful PayPal sales

Create Airtable records for new successful PayPal sales
  • PayPal logo
  • Airtable logo
PayPal + Airtable

Create Google Sheet rows for new Stripe invoices

Create Google Sheet rows for new Stripe invoices
  • Stripe (Legacy) logo
  • Google Sheets logo
Stripe (Legacy) + Google Sheets

Add new Stripe payments to a row on Excel

Add new Stripe payments to a row on Excel
  • Stripe logo
  • Microsoft Excel logo
Stripe + Microsoft Excel

Add new Stripe sales to Airtable

Add new Stripe sales to Airtable
  • Stripe logo
  • Airtable logo
Stripe + Airtable

Connect your business accounts to your accounting app

Another helpful way to streamline and simplify bookkeeping is to link your business accounts—debit card, credit card and bank account—to your accounting app to track income and expenses. These integrations will track every transaction that occurs on your accounts from in-store office supply runs to client lunches. If you link your bank account, it will also track deposits and withdrawals that occur in person at the bank.

You'll no longer have to enter transaction details from physical receipts, eliminating the chance for human error.

Want to learn more about accounting automation? Get advice from experts on the best ways to add automation to your financial processes.

Upload photos of receipts for business purchases on the go

And talking about receipts, there are other ways to add automation to make it easier to track expenses. One option is to take pictures of receipts, and upload them to your accounting app. You can then tag and add notes for the photo as needed to keep things organized. If your accounting app doesn't offer this feature, you can also upload the photos to a file management or cloud storage system such as Google Drive or Dropbox.

Save new attachments from labeled emails in Gmail to Google Drive

Save new attachments from labeled emails in Gmail to Google Drive
  • Gmail logo
  • Google Drive logo
Gmail + Google Drive

Save new email attachments to Dropbox

Save new email attachments to Dropbox
  • Email by Zapier logo
  • Dropbox logo
Email by Zapier + Dropbox

To take the process of tracking physical receipts to another level, you can also use an app like Expensify. They have a SmartScan feature where you take a picture of a receipt, then the app extracts the values and adds them where you need it. It can also create an expense report, so your team no longer needs to manually enter these details.

You can also use automation with Zapier to track reports elsewhere, like saving them as PDFs in Google Drive or adding them to a spreadsheet.

Save new Expensify reports as PDFs in Google Drive

Save new Expensify reports as PDFs in Google Drive
  • Expensify logo
  • Google Drive logo
Expensify + Google Drive

Add new Expensify reports to a Google Sheets spreadsheet

Add new Expensify reports to a Google Sheets spreadsheet
  • Expensify logo
  • Google Sheets logo
Expensify + Google Sheets

Track expenses for service providers on a spreadsheet

There are certain business transactions that might not have an easy way to automatically track in your accounting software. Things like monthly service provider transactions, software fees for email marketing providers or web hosting, or payments for social ads. 

If you've linked your credit card or bank account, those should filter in, but if you haven't done so—or if you want more detailed tracking for these kinds of expenses—you can add these fees to a Google Sheets spreadsheet or Microsoft Excel workbook. Since these transactions tend to have an email that includes the invoice or receipt details, you can easily create a Zap that will pull the needed data from the email and track them in a spreadsheet. 

You can then use new rows in that spreadsheet to upload expenses to your accounting app either as a bulk upload or by using Zapier to make it an ongoing process. Include columns in your spreadsheet for things like transaction category (example: advertising expense, office supply expense, travel expense, etc.), so when you are ready to upload the data, each line item will be seamlessly applied to the correct category. This also eliminates the need to hunt down individual receipts in your inbox.

Take new Gmail emails from a specific sender and add them to a Google Sheets spreadsheet

Take new Gmail emails from a specific sender and add them to a Google Sheets spreadsheet
  • Gmail logo
  • Google Sheets logo
Gmail + Google Sheets

Add row in Microsoft Excel for new Outlook emails with specific term in the subject line

Add row in Microsoft Excel for new Outlook emails with specific term in the subject line
  • Microsoft Outlook logo
  • Filter by Zapier logo
  • Microsoft Excel logo
Microsoft Outlook + Filter by Zapier + Microsoft Excel

You can add a third step to these Zaps to also send this information into your accounting software. To add a step, simply click the plus sign after your spreadsheet step.

Automate bookkeeping and increase efficiency

By using any number of these strategies, you will be sure to simplify your bookkeeping process so you can spend more time working on your business and less time balancing your books.

Related reading:

  • Save time and reduce errors with accounting automation

  • How to create QuickBooks invoices from PDF vendor invoices with Zapier

  • Streamline your accounting processes to track deals, transactions, and more

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'