Re:Connecting to Google Sheets with Python
by foxylad on Thursday November 02, 2017 @08:35PM
(#15615716)
We used to use the excellent Xero for our accounts, but it couldn't handle international business (exchange rates, different tax regimes etc)well. So we rolled our own system of python scripts and Google sheets.
The python scripts use gspread to import and process bank data from eight accounts around the world. Summary sheets pull that data together into real-time profit and loss, position statements, and tax summaries.
It's easily shared with our accountant, who can add a sheet to do some custom analysis at the drop of a hat. Our annual report takes about an hour to prepare, and sheets mimicking tax forms make filing tax returns simple.
Re:Connecting to Google Sheets with Python
by Kunlun on Friday November 03, 2017 @11:49AM
(#15620060)
Sounds awesome! We are in the process of revamping our sheets internally and would love to do something similar. Anything you could share on the subject?
The python scripts use gspread to import and process bank data from eight accounts around the world. Summary sheets pull that data together into real-time profit and loss, position statements, and tax summaries.
It's easily shared with our accountant, who can add a sheet to do some custom analysis at the drop of a hat. Our annual report takes about an hour to prepare, and sheets mimicking tax forms make filing tax returns simple.