We recommend using the Online version of QuickBooks in conjunction with MyTime as it removes any manual data entry and syncs in real time. However, if you currently use QuickBooks Desktop and want to port over your MyTime transaction data, here are two options:
Import Data
To import your data from MyTime via CSV, you’ll need to run a report, download the data, and then import it into QuickBooks. First, decide which MyTime report works best for how your Chart of Accounts is set up in QuickBooks. Often businesses will organize this data by service and product type. To access these two reports and their data follow these steps:
- Service Revenue
- Go to “Reports” then “By Service” under “Appointments”
- Select the desired date range, then select “Update”
- Export the data by selecting the “CSV” icon in the top right
- Product Revenue
- Go to “Reports” then “Product Sales Analysis”
- Select the desired date range, then select “Update”
- Export the data by selecting the “CSV” icon in the top right
Once you have downloaded each report, you’ll need to upload them to QuickBooks. This article has a good summary of the steps, including how to map the columns on each spreadsheet to your QuickBooks accounts.
Manually Copy Data
If you only need to transfer a small amount of data, QuickBooks recommends copying and pasting the data manually. MyTime’s reports update daily and the data can easily be copied over. Again, depending on how you organize your data in QuickBooks, select the appropriate report, date range, and manually copy over the values from MyTime to QuickBooks.