There is an optional download to Quickbooks. The Quickbooks download creates journal entries in Quickbooks for all transactions recorded in Schedule Master. The default download summarizes income and expenses, such as rental and fuel. However, bank transactions, such as customer receipts and refunds, are kept at the detail level to facilitate reconciliation of bank accounts through Quickbooks.
Prepare download of rent and receipt transactions
- If your aircraft are on leaseback (or if you treat the owners as separate vendors), we recommend that you first go through the process to prepare the aircraft owner statements. The step for adding rent and receipts to owner statements and the step for adding aircraft expenses to owner statements create batches of data for download to Quickbooks.
- If your aircraft are not on leaseback, you can prepare the rental income and receipt expenses for download to Quickbooks by going to the Rent/Receipts page (Billing Admin>>Downloads>>Batch Rent/Receipts). Set the parameters for the batch. We suggest creating a separate rental batch for each aircraft and then a receipt batch for all aircraft. A separate rental batch gives you a total of the hours, which gives you a way to double-check the accuracy. More detail on the parameters and steps follow:
- Check Rental Time and/or Aircraft Receipts to determine which types of transactions are included in the batch.
- Set a particular resource or leave set to 'Select Resource' to select all resources.
- Set the schedule cutoff date as desired for your accounting batches. Most organizations would set this to the end of the month.
- Set the accounting date based on the date you would like for the journal entry when created in Quickbooks.
- Click the 'Create Batch' button when you are ready to generate the batch.
- Once that batches are created, click the 'Select' link of the batch you wish to review. This will display the transactions and totals. Once selected, you will see links for clearing the batch or locking the batch for download to Quickbooks.
Prepare download of other transactions
To create download batches for remaining transactions, including payments/refunds, invoice/CM that are not aircraft-related, and owner income/expenses, go to Billing Admin->Downloads->Batch Other Trx (or Billing Admin >> Downloads >> Prepare) and go through the following steps:
- Set the download type, transaction cutoff date, and accounting date (used for Quickbooks transaction date) and click 'Create Batch'. You will need to do this separately for each download type.
- Click Display Batch to see the transactions included in the batch.
- Click Lock Batch after verifying the transactions to prepare for download.
Download Initiation and Results
- The batches of data awaiting download to Quickbooks can be found on the Download Results screen (Billing Admin -> Downloads -> Results). However, the Quickbooks download can only be initiated from the Quickbooks web connector on the desktop computer that has your Quickbooks data. Instructions for setting up the web connector can be found at: http://support.timesync.com/entries/88458-first-time-set-up-of-quickbooks-download
- After the download, the download batches will move from the list of Batches Awaiting Download to the list labeled Download Results. This is on the same Download Results screen from #3. If there was an error writing to Quickbooks, the error message will be displayed.
- For those batches with errors, click the button to reset the batch. This will send the batch back to the batches awaiting download. Be sure to resolve the issue before restarting the Quickbooks download. Some errors might be related to a mismatch of data (e.g. account name) between Quickbooks and Schedule Master.
Please sign in to leave a comment.