To use Frazer and Quickbooks together, there is a three part process to set up the two applications to work together:
•
Part I: Initial Setup Steps,
•
Part II: Linking Your Frazer General Ledger with the Quickbooks General Ledger, (go to Part II)
•
Part III: Transferring Your Frazer G/L Data to Quickbooks (go to Part III).
NOTE: This is not a ‘Live’ link between the two applications. To transfer the data, you manually have to follow the steps in Part II each time you want to transfer from Frazer to Quickbooks. You will only have to follow the steps in Part I once to get this process set up.
As of this writing, we know that Frazer will work with the following versions of Quickbooks:
•
2005
•
2006
•
2007
•
2008
This does not include any free versions or the online versions.
Initial Setup Steps
Step 1: Print out some Chart of Account information from the Frazer System.
1.
In Frazer, click on Accounting > 3–Chart of Accounts.
2.
In the Chart of Accounts window, click on Print. This will give you a list of all the accounts that are in Frazer
3.
Now, Click Here to view and print the main Frazer Chart of Accounts.
4.
In the top of the Help Manual screen, click Print. This will print out a list of each account, arranged by type, along with a definition of each account so you understand how the account works and what it is used for.
Step 2: Create a Chart of Accounts in Quickbooks that mirrors the Chart of Accounts in Frazer.
1.
Back up your Quickbooks data.
2.
Open your Company file in Quickbooks.
3.
Click the Chart of Accounts button.
4.
Use the Chart of Accounts we printed from Frazer to add to your Quickbooks Chart of Accounts:
a.
In the Chart of Accounts window, click on the Accounts button and choose New, OR, press Ctrl + N on your keyboard to create a new account.
b.
In the New Account window:
i.
Select an Account Type.
NOTE: It is very important to match your Quickbook Account Types with the Account Types that are assigned to each Frazer account. If you use the wrong Account Type in Quickbooks, you will be unable to link the account to it’s proper corresponding account in Frazer.
Matching Account Types:
Frazer
Quickbooks
Asset
Other Asset/Other Current Asset
Liability
Other Current Liability
Sales
Income
Cost of Sales
Cost of Goods Sold
Expense
Expense
Accounts Receivable
Other Current Asset*
Accounts Payable
Other Current Liability*
* Quickbooks automatically creates invoices/bills for any data transferred to an Accounts Receivable or Accounts Payable account. Using the recommended account types will keep things simpler for you.
ii.
In the Name field, enter the name of the account as it appears in the Frazer Chart of Accounts. Ex. Cash, Contracts in Transit, etc. You can also use the optional account numbers in Quickbooks to match Frazer.
iii.
In the Description field, enter a breif description of the account.
iv.
In the Bank Acct. No. field, you may enter a back account number if there is one related to the account you are entering in Quickbooks. For example: You may want to link your 1010 – Cash account from Frazer to a business checking account. Enter that account number here.
v.
Leave the Opening Balance field blank as Frazer does not currently hold account balances.
vi.
Click OK to save the new acccount.
vii.
Repeat these steps until you have all of the accounts listed in the Frazer Chart of Accounts entered into Quickbooks.
Once you have completed Part I of the Quickbooks Interface setup, you are ready to proceed with Part II.