cancel
Showing results for 
Search instead for 
Did you mean: 
JamieW2
Level 1

How to get spreadsheets (specifically Google Sheets) to automatically populate in Quickbooks Desktop?

My Cpa is old school and is not well versed with technology. I renovate houses for a living, around 75 yearly.  We already have many spreadsheets setup for internal expense tracking that is being entered via google sheets.  My thought was to set up our current spreadsheets on a document that would either in real time update quickbooks or could be imported seamlessly so there would not have to be double entry.  

 

We need our spreadsheet views for company purposes or I would have the project manager just input them into Quickbooks but there is also a learning curve and I assume with the technology this should be something simple once the "new spreadsheet" was setup to include the needed titles, classes ect that could integrate seamlessly again without double entry.

 

Any suggestions or help would be greatly apprecaited.

2 Comments 2
Fiat Lux - ASIA
Level 15

How to get spreadsheets (specifically Google Sheets) to automatically populate in Quickbooks Desktop?

Just to clarify. Are you using QB Desktop for Mac?

RenjolynC
QuickBooks Team

How to get spreadsheets (specifically Google Sheets) to automatically populate in Quickbooks Desktop?

I hope you're doing well, JamieW2.

 

I'd like to give some details about adding your data.

 

In QuickBooks Desktop for Mac, you have an option to import your customers, vendors, employees, and items from a spreadsheets. For more information about the process, please check out this article: Import data into QuickBooks for Mac.

 

As for integrating your Google Sheets account, I recommend reaching out to their support team and check to see if there's a way to automatically populate the data. 

 

Otherwise, visit the Apps for QuickBooks Desktop page and search for an app with a similar function. 

 

If you have more questions or need help with other task in your account, please let me know in your reply. I'll be happy to assist you again. Have a good day ahead.

Need to get in touch?

Contact us