Total Party Planner will recreate an invoice in QuickBooks very similar as it appears in Total Party Planner, including all menu, beverage, rental, staffing, taxing, and service charge detail.
Pre-requisite:
TPP Web currently interfaces with QuickBooks Pro (Desktop) Versions 2002 or higher.
1. Installation
a. Download the Total Party Planner Interface Setup File
i. Visit our website www.totalpartyplanner.com
ii. Choose ‘Web Based Solution’.
iii. From the top navigation menu, select ‘Web Solution | Web Solution Support’.
iv. Click the link ‘TPP Web Interfaces Full Install’.
v. When prompted, click the ‘Save’ button.
vi. In the ‘Save In’ window, select a download location for the file. For easy access, it is recommended that you save the file directly to the desktop. The file will take a couple minutes to download.
vii. Find the file on your local machine that was just downloaded. Double click the file or icon if it was downloaded to your desktop.
viii. Click the ‘Run’ button.
ix. Follow the wizard instructions for installation.
b. Download the Intuit (QuickBooks) Interface Support Files
i. Visit our website www.totalpartyplanner.com
ii. Choose ‘Web Based Solution’.
iii. From the top navigation menu, select ‘Web Solution | Web Solution Support’.
iv. Click the link ‘Intuit (QuickBooks) Interface Support Files’.
v. When prompted, click the ‘Run’ button.
vi. Follow the wizard instructions for installation.
2. Opening the QuickBooks Interface
a. Open your QuickBooks company file as normal, however, you must be logged in as an Administrator. QuickBooks must be running in the background for Total Party Planner to export data.
b. After installing the file in step 1, you will see a new icon on the desktop called ‘TPP Web Interfaces’. Double-click that icon.
c. When prompted for a Username and Password, enter the same information you would if logging directly into the TPP Web application from the internet.
d. Click the ‘Login’ button.
e. If prompted, select a business to manage from the drop-down list and click the ‘Select’ button. This screen will only appear if you are managing multiple businesses through the application.
3. Selecting the Local QuickBooks File
a. From the top Navigation Bar, select ‘QuickBooks | Setup’.
b. The ‘Total Party Planner QuickBooks Setup’ window will appear.
c. Find your QuickBooks company file (the one currently opened in QuickBooks) by clicking the ‘Browse’ button. If you do not know the location of your QuickBooks company file, please see your administrator.
d. Once you have found your company file from the explorer window and click the ‘Save’ button.
e. Click the ‘Save & Close’ button.
4. Selecting Invoices to Export
a. From the top menu bar, select ‘QuickBooks | Export Invoices’.
b. When selecting this option for the first time, the QuickBooks security window will appear showing the certificate status for our company. Allow Total Party Planner access to the file by choosing the ‘Yes, Always’ button.
c. The ‘Select Export Events’ window appears with data in the grid.
i. By default, the data grid rows displayed is loaded with the current months Events. The date range can be updated by changing the dates inside the ‘Dates’ frame.
ii. Change the status of Events displayed via the drop-down list inside the ‘View Status:’ frame.
iii. Click the ‘Retrieve Events’ button.
iv. Put a check mark (by clicking the row) in the first column of the grid labeled ‘Sel’ for the invoice(s) to be exported. Multiple rows may be selected for export.
5. Assign Tax Rules
a. Assign a QuickBooks tax value for each invoice checked. Note that the tax that you assigned in Total Party Planner is shown in the grid under the column labeled ‘TPP Tax’. There are two ways to assign a QuickBooks Event tax.
i. Use the ‘Default Event Tax’ drop-down box to quickly assign a single tax to ALL the selected Events.
ii. Assign taxes individually at the Event level. The tax value is assigned for each selected row under the column labeled ‘QkBks Tax’. Click that row column for a list of QuickBooks takes to select from.
6. Select a Payment Account
a. Any payments applied to an Event will also be exported with the other Event detail.
b. Select an account to deposit the payment into from the ‘Deposit Payments To’: drop-down list.
IMPORTANT: Payments marked as ‘Deposit’ in Total Party Planner will NOT be exported to QuickBooks. Because the money will typically be deposited before the Event is complete, you will manually add deposits into QuickBooks. This is by design so that the invoice does not have to be exported multiple times to reconcile changes.
7. Initiate the Export Process
a. Review your tax settings as this is probably the biggest reason why there may be a discrepancy between Total Party Planner totals and the QuickBooks export total.
b. Click the ‘Export Sel. to QuickBooks’ button.
8. The Export Process Prompts
a. New Clients
i. If a Total Party Planner Client does not exist in QuickBooks, the ‘Define QuickBooks Name’ window appears.
ii. Type in the company name you would like to save this client as in the ‘Customer Name’ field, or simply leave the default value.
iii. Click the ‘Assign’ button.
b. New Items (Menu, Beverage, Miscellaneous, Staff, etc.)
i. If a Total Party Planner item does not exist in QuickBooks the ‘QuickBooks Account Select’ window appears.
ii. Type in the name of the item in the ‘Item Name:’ text box, or simply leave the default value.
iii. Select the ‘Account Type’ as Service and any valid SALES ‘Account’ (you cannot export to accounts receivable, accounts payable, liability, etc accounts!). If the new item should be listed under a sub-account of the selected account, check the ‘Sub-item of:’ checkbox.
iv. Select the appropriate tax code (item is taxable or non-taxable) from the ‘Tax Code:’ drop-down list. This is the general taxing rule for the item being defined.
v. Click the ‘Assign’ button.
9. Export Confirmation
a. Once the invoice has been exported, the ‘Invoice Display’ window appears. This screen displays the detail line items of the new QuickBooks invoice.
b. Click the ‘OK’ button to continue exporting any other selected invoices, or end the exporting process.
10. Discrepancies
After exporting Total Party Planner details to QuickBooks, there may be discrepancies in the totals between the two applications. You will be warned that a difference was found.
a. From the top menu bar, click the ‘QuickBooks | Export Discrepancies’ option.
b. The detail grid columns list the Invoice #, Total Party Planner Total, QuickBooks Total, and the date the invoice was exported to QuickBooks. Use this information to research the invoices in both applications. Some common mistakes are:
i. Incorrect Event tax assigned, perhaps the Event was marked exempt in Total Party Planner.
ii. Incorrect tax declaration (taxable or non taxable) at the item level.
iii. The service charge was not marked as taxable in QuickBooks.
c. Fixing Discrepancies
i. There is no way to automatically detect and correct an invoice discrepancy. Once exported to QuickBooks, you must research and fix the invoice record in QuickBooks, or delete the invoice and export it again. When the error is fixed, click the ‘I Fixed It’ button to remove the record from the grid.