timetagger
timetagger copied to clipboard
almarklein
Feature Request: QuickBooks Online Integration
Any chance of adding a time-import to QuickBooks Online? Downloading and Uploading CSV files is it's own beast in terms of compliance but a direct-data import to a major bookkeeping product would be mint.
Sure! Would you be able to provide a few lines of (anonymized) CSV that QuickBooks generates? I could then try to adjust the timetagger import dialog to recognize it, and let you test-drive it.
Yes! I will send you something this week as time permits at work.
On Sun, Jan 8, 2023, 5:08 PM Almar Klein @.***> wrote:
Sure! Would you be able to provide a few lines of (anonymized) CSV that QuickBooks generates? I could then try to adjust the timetagger import dialog to recognize it, and let you test-drive it.
— Reply to this email directly, view it on GitHub https://github.com/almarklein/timetagger/issues/316#issuecomment-1374939705, or unsubscribe https://github.com/notifications/unsubscribe-auth/AGZ55UTILALPXUVXEGP7PBLWRM3EDANCNFSM6AAAAAATTJZAPA . You are receiving this because you authored the thread.Message ID: @.***>
Here is the REST API from QBO if it helps in the meantime.
https://developer.intuit.com/app/developer/qbo/docs/get-started
On Sun, Jan 8, 2023, 9:10 PM Joey Trumble @.***> wrote:
Yes! I will send you something this week as time permits at work.
On Sun, Jan 8, 2023, 5:08 PM Almar Klein @.***> wrote:
Sure! Would you be able to provide a few lines of (anonymized) CSV that QuickBooks generates? I could then try to adjust the timetagger import dialog to recognize it, and let you test-drive it.
— Reply to this email directly, view it on GitHub https://github.com/almarklein/timetagger/issues/316#issuecomment-1374939705, or unsubscribe https://github.com/notifications/unsubscribe-auth/AGZ55UTILALPXUVXEGP7PBLWRM3EDANCNFSM6AAAAAATTJZAPA . You are receiving this because you authored the thread.Message ID: @.***>
Here we go, this has an example of the timesheet. Fairly straight-forward. https://quickbooks.intuit.com/learn-support/en-us/employees-and-payroll/import-timesheet-as-a-csv-file/00/1109314
Pasting here for simplicity:
Prepare your Time Tracking data with the following template
| Name | Transaction Date | Customer | Service Item | Payroll item | Duration | Class | Billable | Notes |
|---|---|---|---|---|---|---|---|---|
| John Marks | 01/09/2020 | Nguyen, Tuan | Labor | Regular Pay | 1:25 | |||
| John Smith | 02/09/2020 | Nguyen, Tuan | Labor | Regular Pay | 2:00 | |||
| Karen Marks | 02/09/2020 | Links, John | Labor | Regular Pay | 1:25 | |||
| Kathy Linklater | 02/09/2020 | Links, John | Labor | Regular Pay | 1:25 | |||
| Johnny Deep | 02/09/2020 | Links, John | Labor | Regular Pay | 2:00 |
This is for importing data into QB, or is this also the format that it exports data to?
Import format. I'm not sure of the export format.
On Mon, Jan 9, 2023, 11:14 AM Almar Klein @.***> wrote:
Pasting here for simplicity:
Prepare your Time Tracking data with the following template Name Transaction Date Customer Service Item Payroll item Duration Class Billable Notes John Marks 01/09/2020 Nguyen, Tuan Labor Regular Pay 1:25 John Smith 02/09/2020 Nguyen, Tuan Labor Regular Pay 2:00 Karen Marks 02/09/2020 Links, John Labor Regular Pay 1:25 Kathy Linklater 02/09/2020 Links, John Labor Regular Pay 1:25 Johnny Deep 02/09/2020 Links, John Labor Regular Pay 2:00
This is for importing data into QB, or is this also the format that it exports data to?
— Reply to this email directly, view it on GitHub https://github.com/almarklein/timetagger/issues/316#issuecomment-1375889337, or unsubscribe https://github.com/notifications/unsubscribe-auth/AGZ55UQR6TMY2NTHDUBNAQDWRQ2ORANCNFSM6AAAAAATTJZAPA . You are receiving this because you authored the thread.Message ID: @.***>