About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces Zapier Canvas Zapier Chatbots

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Tracking money coming in and out of accounts

  • 12 January 2023
  • 1 reply
  • 464 views
W

What would be the best way to track the expenses in a bank account to produce somekind of cashflow statement. 

The scenario i am thinking of is:

Perhaps a thirdparty app like the ones that show all your bank accounts balances and expenses that are relativley low in securtiy of some kind that tracks money coming into accounts 

Connecting this app to a google sheets perhaps to produce some sort of cashlow forecast

Anyone know how this can be done and what apps to use? 

Thank you. 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

SamB
Rank
Userlevel 7
Badge +11

Good question @wisdom seeker! 

There’s a number of third-party accounting related apps that would be able to connect to your bank and pull in a feed of all it’s transactions. I know apps like QuickBooks and Xero for example have the sort of “bank feed” feature you’re talking about. Often these type of apps will already have cashflow forecasting built in. I’m not sure about Xero but I believe QuickBooks has a built-in cashflow planner.

If you’re looking to use Google Sheets to produce your own forecast you would need to use your chosen app that connects to your bank as the Trigger for your Zaps. Then have a Google sheets action add the information into a spreadsheet that you could then use for creating your forecast. 

For example the following templates could be used to add details of new expenses and payments in QuickBooks into Google Sheets:


If you were wanting a Zap to automatically generate the cashflow forecast in Google Sheets, I don’t think that would be possible. So your best bet may be to use a cashflow forecasting feature that’s built into an accounting app of your choice or use a separate cashflow forecasting app. Like Cash Flow Frog for example.

The best apps to use will really depend on your own needs and preferences. Every app’s features and interface are slightly different and more often than not it will just come down to which app you prefer to use. I’d recommend exploring the apps listed in the Accounting category to see what one will work best for your needs.

Hope that helps to get you started! 🙂

Terms & Conditions