General Ledger Accounts and QuickBooks Integration
When you use QuickBooks Online with Vantagepoint, you set up general ledger accounts in QuickBooks Online and map them to corresponding accounts in Vantagepoint.
Transactions Created with General Ledger Accounts that Are Not Mapped
If you create transactions that are shared between Vantagepoint and QuickBooks Online using general ledger accounts that are not mapped between Vantagepoint and QuickBooks Online, the transactions are not added to the other product.
General Ledger Account Number and Name
Vantagepoint requires a general ledger account to have a name and number. QuickBooks Online requires only an account name. It is best practice to have the account names match in both Vantagepoint and QuickBooks Online. If you use account numbers in both Vantagepoint and QuickBooks Online, the account number formatting must be the same in both.
Initial Mapping of General Ledger Accounts
When you run the initialization process during the initial QuickBooks integration setup, the following mapping occurs:
- If you use only account names in
Vantagepoint and QuickBooks Online: A general ledger account from QuickBooks Online is automatically mapped to a general ledger account in
Vantagepoint if a match is found, based on the account name.
If a match is not found in Vantagepoint, you must manually map the account.
- If you use both account names and numbers in
Vantagepoint and QuickBooks Online: A general ledger account from QuickBooks Online is automatically mapped to general ledger accounts in
Vantagepoint if a match is found, based on account name and account number.
If a match is not found in Vantagepoint, a matching account is created in Vantagepoint and mapped with the QuickBooks Online account.
The accounts are added to Vantagepoint in .
If you used the Vantagepoint QuickBooks Integration utility to set up the integration between Vantagepoint and QuickBooks Online: For more information on initially mapping general ledger accounts, see Map General Ledger Accounts Between Vantagepoint and QuickBooks Online for the First Time.
Adding New General Ledger Accounts
If you used the Deltek Unionpoint to set up the integration between Vantagepoint and QuickBooks Online: For more information see Vantagepoint - QuickBooks Online.
f you used the Vantagepoint QuickBooks Integration utility to set up the integration between Vantagepoint and QuickBooks Online: For more information, see Map New General Ledger Accounts Between Vantagepoint and QuickBooks.
Mapping the Employee Expense Report Accounts
When you set up a liability account to use for employee expense reports, you must map the liability account in Vantagepoint to a specific QuickBooks Online account whose type is Accounts Payable (AP). If you fail to do this, expense reports entered in Vantagepoint will not be added to QuickBooks Online.
Subcontractor Accrual Account 213.00
A subcontractor accrual account 213.00 comes standard with Vantagepoint. It is used for offsetting transactions for consultant accruals in Vantagepoint. You must not map this account to a valid accounts payable account in QuickBooks Online. If you do, consultant accruals will not be processed correctly between Vantagepoint and QuickBooks Online.
You can link the subcontractor accrual account 213.00 to a miscellaneous account in QuickBooks Online.