The QuickBooks Link has two main screens; the Main Control Panel that comes up first when you open the QuickBooks Link, and the Accounting Utilities Control Panel that comes up when you click the Utilities button from the Main Control Panel. Click the links below for basic overview details for the different buttons and features found in the QuickBooks Link:
The Main QuickBooks Link Control Panel
This screen comes up when you first open the QuickBooks Link. Click the links below for information on what each button does:
Output-Vouchers Button
Brings up the Voucher Export Manager for outputting "To Post" Vouchers out to QuickBooks:
Output-Invoices Button
Brings up the Invoice Export Manager for outputting "To Post" Invoices out to QuickBooks:
Output-Booking Button
Brings up the Journal Export Manager used with Progressive Billings to output Journal Entries and convert deposits to Revenue:
Output Payment Button
Runs the Output process for outputting received progressive payments to QuickBooks. There is no intermediary step for this. Once the button is clicked, you will see a series of windows and when the process is finished, you will get a confirmation screen as pictured below. Click here for information on tracking payment histories in BusinessMaster.
BMS-GL Setup Button
Brings up the General Ledger to QuickBooks Manager for mapping GLAcctNums in BusinessMaster to their correct counterparts in QuickBooks. The GL Accounts in BusinessMaster must be mapped to existing GL Accounts in QuickBooks for the QBLink to work correctly:
BMS-PartGLSetup Button
Brings up the PartsGeneral Ledger to QB Manager for mapping Item COGSAccts in BusinessMaster to their correct QBIncomeGLAcct's in QuickBooks. If these are not defined here, the QuickBooks Link will use the defaults as listed in the QB Preferences:
Missing Invoice Parts in QB Button
Brings up the Missing Parts in QuickBooks Manager. This goes and checks your Invoices for any Parts that are not yet in QuickBooks.
Utilities Button
Brings up the Accounting Utilities Control Panel:
<Back to Top of Page>
Accounting Utilities Control Panel <Top>
This Screen is accessed by clicking the Utilities button from the Main QuickBooks Link Control Panel. Click the links below for information on what each button does:
Vouchers Button
Brings up the QB Voucher Edit Manager, which you can use to view and edit your existing Vouchers. (Click here for more information on Vouchering in BusinessMaster):
Voucher Export Button
Brings up the Voucher Export Edit Manager. From this screen you can view the history of all exported Vouchers by Voucher Number, Vendor Invoice Number, Vendor Invoice Date, the Exported Statuses, and the Batch Number the Exported Voucher was assigned:
Invoices Button
Brings up the QB Invoice Edit Manager, which you can use to view and edit your existing Invoices. (Click here for more information on Invoicing in BusinessMaster):
Invoice Export Edit Button
Brings up the Invoice Export Edit Manager. From this screen you can view the history of all exported Invoices by Invoice Number, Company Name, Invoice Date, the Exported Statuses, and the Batch Number the Exported Invoice was assigned:
UpdateLocalData Button
Runs a routine to verify the connection to QuickBooks and checks the accounting data in QuickBooks.
CloseConnection Button
Manually Closes the active connection to QuickBooks if there has been a problem. This is basically a troubleshooting tool for Master Solutions.
QB Preferences Button
Brings up the QuickBooks Preferences Manager that is used to map the GLAccounts and set the path to your Company QuickBooks file:
QBFilePath
Displays the path to the QuickBooks file.
GetQBFilePatch
Opens the Browser to locate and select the QuickBooks File.
ARAccount
Your default AR Account.
SalesDebitAccount
Your default SalesDebitAccount Account.
DefaultAsset
Your Default Asset Account.
Default COGS
Your Default COGS Account.
Default SALES
Your Default SALES Account.
A/P Class
Your default A/P Class.
A/R Class
Your default A/R Class.
OutputBillsDetailedYN
If checked, it will include the Job Number on the Bill Detail in QuickBooks.
Use Cust ID
If checked, it will use the Customer ID (instead of company name, unique thing that requires training) in QuickBooks for the Invoice reference.
Check Each Inv to QB
If checked, it will give you confirmation for each Invoice as it is exported to QuickBooks. Due to limitations inherent in QuickBooks, checking this off could make processing really slow if your QuickBooks file is large, and/or network traffic is significant. In general we recommend you not use this setting.
Check Each Bill to QB
If checked, it will give you confirmation for each Bill as it is exported to QuickBooks. Due to limitations inherent in QuickBooks, checking this off could make processing really slow if your QuickBooks file is large, and/or network traffic is significant. In general we recommend you not use this setting.
A/P Class
Sets the default class to be used for A/P
A/R Class
Sets the default class to be used for A/R
ItemsAsInventoryYN
If checked, it will export new items as inventory items when they are first sent to QuickBooks.
Update Local Preferences
Clicking this brings up any preferences that have been set here before if present in the Master Preferences for the Accounting Link.
Update Master Preferences
Clicking this button updates the Master Preferences with whatever you have entered.
AddInventoryItems Button
Checks your Invoices for New Items not listed in QuickBooks and adds them. If you don't choose the option to just check Invoices, it will check your entire item list. This could be a lengthy process, depending on your data. It could also clutter your QuickBooks file with a lot of unneccessary data. We recommend you only check Invoices, to avoid that scenario.
AddCustomers Button
Adds New Customers from the BusinessMaster AddressBook, or just from BusinessMaster Invoices into QuickBooks. We recommend only adding customers from Invoices, to help keep your QuickBooks data accurate.
AddVendors Button
Adds New Vendors from BusinessMaster AddressBook, or just from BusinessMaster Vouchers into QuickBooks. We recommend only adding customers from Vouchers, to help keep your QuickBooks data accurate.
Import Data From QB Button
Imports Data from QuickBooks into BusinessMaster. There is a process to doing this properly, so please check with us before attempting to use this feature. Here are the confirmation windows that come up, asking you what you wish to import from QuickBooks:
ShowErrorLog Button
Brings up the Error Log used by Master Solutions in troubleshooting exporting problems.
Relink Files Button
Brings up the EZ Attachment Manager used for linking the QuickBooks link to your BusinessMaster data files. Click here for the basic setup process for the QuickBooks Link:
<Back to Top of Page>
