Open trumblejoe opened 1 year ago
almarklein
commented
1 year ago 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.
trumblejoe
commented
1 year ago 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: @.***>
trumblejoe
commented
1 year ago 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: @.***>
trumblejoe
commented
1 year ago 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
almarklein
commented
1 year ago 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?
trumblejoe
commented
1 year ago 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: @.***>
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.