ITrack/Pro/Quickbooks Screen/Installation - Revision history

Nenjin: /* Installing on the client machine */

2019-03-26T21:10:23Z

Installing on the client machine

← Older revision		Revision as of 16:10, 26 March 2019
Line 4:		Line 4:
	We can not link Quickbooks and ITrack Pro until the customer has Quickbooks all set up (because we don't know - and shouldn't know - the inner workings of the customer's accounting methods). Once Quickbooks is set up according to their accounting methods just follow these steps:		We can not link Quickbooks and ITrack Pro until the customer has Quickbooks all set up (because we don't know - and shouldn't know - the inner workings of the customer's accounting methods). Once Quickbooks is set up according to their accounting methods just follow these steps:

	# Install the latest version of the Quickbooks SDK (currently qbfc12.0 and qbsdk13.0)		# Install the latest version of the Quickbooks SDK (currently qbfc12.0 and qbsdk13.0)(For Enterprise use QBFC8.0)
	# Put Quickbooks into multi-user mode (File->Switch to Multi-User mode)		# Put Quickbooks into multi-user mode (File->Switch to Multi-User mode)
	# Make sure the ITrack Quickbooks Toolkit is pointed at the same company file as the one open in Quickbooks (to find possibilities of where the QB Company file might be, go to 'File >> Open Previous Company'.		# Make sure the ITrack Quickbooks Toolkit is pointed at the same company file as the one open in Quickbooks (to find possibilities of where the QB Company file might be, go to 'File >> Open Previous Company'.

Codeman: /* Integrating ITrack Pro and QuickBooks */

2017-12-01T23:05:26Z

Integrating ITrack Pro and QuickBooks

← Older revision		Revision as of 18:05, 1 December 2017
Line 54:		Line 54:
	* Part type		* Part type
	* Category		* Category

			{{Tip\|You will need to be logged into QuickBooks under an administrator account before continuing}}

	== Integrating ITrack Pro and QuickBooks ==		== Integrating ITrack Pro and QuickBooks ==

Codeman: /* Configuring the Accounts */

2017-05-08T19:44:12Z

Configuring the Accounts

← Older revision		Revision as of 14:44, 8 May 2017
Line 108:		Line 108:
	** Credit Memo Account: Accounts Receivable; a credit memo is a negative invoice in ITrack.		** Credit Memo Account: Accounts Receivable; a credit memo is a negative invoice in ITrack.
	** Payment Account: Use the Accounts Receivable account.		** Payment Account: Use the Accounts Receivable account.
	** Check Bank: The bank that the company goes to; this will write a refund check (to a customer) into QB from ITrack.		** Check Bank: The bank that the company goes to; this will write a refund check (to a customer) into QB from ITrack. If no bank exists, one can be created through the Chart of Accounts.
	** Check Account: Use the Accounts Receivable account like the Payment Account.		** Check Account: Use the Accounts Receivable account like the Payment Account.
	** Invoice Other: Assign this to the Misc. Part Type that we pushed over earlier. Any misc line item in ITrack will hit this account.		** Invoice Other: Assign this to the Misc. Part Type that we pushed over earlier. Any misc line item in ITrack will hit this account.

Codeman at 22:46, 28 November 2014

2014-11-28T22:46:30Z

← Older revision		Revision as of 17:46, 28 November 2014
Line 5:		Line 5:

	# Install the latest version of the Quickbooks SDK (currently qbfc12.0 and qbsdk13.0)		# Install the latest version of the Quickbooks SDK (currently qbfc12.0 and qbsdk13.0)
	~~##Requires a restart.~~
	# Put Quickbooks into multi-user mode (File->Switch to Multi-User mode)		# Put Quickbooks into multi-user mode (File->Switch to Multi-User mode)
	# Make sure the ITrack Quickbooks Toolkit is pointed at the same company file as the one open in Quickbooks		# Make sure the ITrack Quickbooks Toolkit is pointed at the same company file as the one open in Quickbooks (to find possibilities of where the QB Company file might be, go to 'File >> Open Previous Company'.
	# Initiate communication with Quickbooks from the ITrack Quickbooks Toolkit		# Initiate communication with Quickbooks from the ITrack Quickbooks Toolkit.
	# Go back to Quickbooks, set it up to always be able to communicate, even when Quickbooks is not turned on		# Go back to Quickbooks, set it up to always be able to communicate, even when Quickbooks is not turned on.

	== Dependencies ==		== Dependencies ==
Line 57:		Line 56:

	== Integrating ITrack Pro and QuickBooks ==		== Integrating ITrack Pro and QuickBooks ==
	* You will need to know where the QuickBooks Company File is stored. Once you have that information, on the QuickBooks Toolkit there is a textbox at the top of the screen; click the "Browse" button and navigate to where the QuickBooks Company File is stored.		* You will need to know where the QuickBooks Company File is stored. Once you have that information, on the QuickBooks Toolkit in ITrack Pro there is a textbox at the top of the screen; click the "Browse" button and navigate to where the QuickBooks Company File is stored.
	* Integrating ITrack Enterprise with QuickBooks is a whole different ballgame...		* Integrating ITrack Enterprise with QuickBooks is a whole different ballgame...

Line 75:		Line 74:
	[[File:ExportVendors.png]]		[[File:ExportVendors.png]]
	* To verify that the vendors made it over, you can click the "Vendors" button in the top toolbar inside of QuickBooks.		* To verify that the vendors made it over, you can click the "Vendors" button in the top toolbar inside of QuickBooks.

	~~=== Push Over the Misc. Part Type ===~~
	* For later configuration efforts, you will probably want to push over the Misc. Part type. Go to the Part Types in the QuickBooks screen inside of ITrack Pro.
	* Click the "Select None" button.
	* Scroll down to the bottom of the page and check the box next to Number 9990 - Miscellaneous Parts; then hit the "Export" button.

	=== Push Over Salespeople and Payment Types ===		=== Push Over Salespeople and Payment Types ===
Line 89:		Line 83:
	[[File:SynchPaymentTypes.png]]		[[File:SynchPaymentTypes.png]]
	* You can check on the sales representative list in QuickBooks by going to 'Lists >> Customer & Vendor Profile Lists >> Sales Rep List'. You can check the payment types in QuickBooks by going to 'Lists >> Customer & Vendor Profile Lists >> Payment Method List'.		* You can check on the sales representative list in QuickBooks by going to 'Lists >> Customer & Vendor Profile Lists >> Sales Rep List'. You can check the payment types in QuickBooks by going to 'Lists >> Customer & Vendor Profile Lists >> Payment Method List'.

			=== Push Over the Misc. Part Type ===
			* You may need to configure some of the accounts before you can push over the Misc Part Type.
			* For later configuration efforts, you will want to push over the Misc. Part type. Go to the Part Types in the QuickBooks screen inside of ITrack Pro.
			* Click the "Select None" button.
			* Scroll down to the bottom of the page and check the box next to Number 9990 - Miscellaneous Parts; then hit the "Export" button.

	=== Configuring the Accounts ===		=== Configuring the Accounts ===
	* '''YOU WILL NEED TO CHECK WITH THE COMPANY ACCOUNTANT/BOOKKEEPER TO COMPLETE THIS SECTION'''		* '''YOU WILL NEED TO CHECK WITH THE COMPANY ACCOUNTANT/BOOKKEEPER TO COMPLETE THIS SECTION'''
	* This is the internal accounting principles that the specific customer runs by, you can not assume that it will be the same for every yard, so be very careful here. Even so, here is a general idea of what you are looking for on the Config tab:		* This is the internal accounting principles that the specific customer runs by, you can not assume that it will be the same for every yard, so be very careful here. Even so, here is a general idea of what you are looking for on the Config tab:
	** Part Type Income Account: Inside of QuickBooks, create a new Income Account called 'ITrack Sales' and make it a subaccount of the main Income Account. After 'ITrack Sales' is created then assign it to the Part Type Income Account in ITrack. ~~<h6~~>~~<font color=~~'~~red~~'~~>[Needs more in-depth steps~~ of ~~how to do this]</font></h6>~~		** Part Type Income Account: Inside of QuickBooks, create a new Income Account called 'ITrack Sales' and make it a subaccount of the main Income Account. After 'ITrack Sales' is created then assign it to the Part Type Income Account in ITrack.
	** Part Type Expense Account: ~~This is~~ not really used~~, you can leave it blank~~.		*** Go to Lists >> Chart of Accounts
	** Tax Type Vendor: The Vendor that tax types should be associated with. Probably the ~~IRS or~~ State Revenue ~~Service~~, if the accountant does not want to use that, then you can create a vendor called 'Sales Tax' in QuickBooks and assign it to the Tax Type Vendor in ITrack. ~~<h6><font color='red'>[Needs more in-depth steps of how to do this]</font></h6>~~		*** Click on the Account button at the bottom of the page and choose 'New'.
	** Credit Memo Account: ~~The bank that the company goes to~~.		*** Chose the selection 'Income', then click 'Continue'.
	** Payment Account: Use the Accounts Receivable account. ~~<h6><font color='red'>[Show where that is at in QuickBooks]</font></h6>~~		*** The account name should be ITrack Sales, check the Subaccount checkbox then make this new account a subaccount of Sales.
	** Check Bank: The bank that the company goes to.		*** Click 'Save & Close'.
			** Part Type Expense Account: Create a new account for this, called 'ITrack Expense'.
			*** Go to Lists >> Chart of Accounts
			*** Click on the Account button at the bottom of the page and choose 'New'.
			*** Chose the selection 'Expense', then click 'Continue'.
			*** The account name should be ITrack Expense. You do not need to make this a subaccount of anything; this doesn't really get used for anything anyway.
			*** Click 'Save & Close'.
			** Tax Type Vendor: The Vendor that tax types should be associated with. Probably the State Revenue Department of Revenue (ex: Nebraska Department of Revenue), if the accountant does not want to use that, then you can create a vendor called 'Sales Tax' in QuickBooks and assign it to the Tax Type Vendor in ITrack.
			** Credit Memo Account: Accounts Receivable; a credit memo is a negative invoice in ITrack.
			** Payment Account: Use the Accounts Receivable account.
			** Check Bank: The bank that the company goes to; this will write a refund check (to a customer) into QB from ITrack.
	** Check Account: Use the Accounts Receivable account like the Payment Account.		** Check Account: Use the Accounts Receivable account like the Payment Account.
	** Invoice Other: Assign this to the Misc. Part Type that we pushed over earlier.		** Invoice Other: Assign this to the Misc. Part Type that we pushed over earlier. Any misc line item in ITrack will hit this account.
	** Invoice Account: ~~Something related to '~~Accounts Receivable'. ~~<h6><font color=~~'~~red~~'~~>[Needs better instructions]</font></h6>~~		** Invoice Account: Accounts Receivable. Any inventory item that is put on an invoice (besides misc line items) will hit this account. If you push part types over it will further divide into part types (Ex: if you have the engine part type pushed into QB and you sell an engine in ITrack, it will hit the 'Engine' item in QB and affect sales in QB.

	{{Tip\|Payments exported to QuickBooks get sent to the "Undeposited Funds" account, even if the account is renamed to something else.}}		{{Tip\|Payments exported to QuickBooks get sent to the "Undeposited Funds" account, even if the account is renamed to something else.}}

Codeman: /* Installing on the client machine */

2014-11-28T16:22:55Z

Installing on the client machine

← Older revision		Revision as of 11:22, 28 November 2014
Line 4:		Line 4:
	We can not link Quickbooks and ITrack Pro until the customer has Quickbooks all set up (because we don't know - and shouldn't know - the inner workings of the customer's accounting methods). Once Quickbooks is set up according to their accounting methods just follow these steps:		We can not link Quickbooks and ITrack Pro until the customer has Quickbooks all set up (because we don't know - and shouldn't know - the inner workings of the customer's accounting methods). Once Quickbooks is set up according to their accounting methods just follow these steps:

	# Install the latest version of the Quickbooks SDK (currently ~~[http://downloads~~.~~isoftdata.com/QBSDK80.exe 8~~.0])		# Install the latest version of the Quickbooks SDK (currently qbfc12.0 and qbsdk13.0)
	##Requires a restart.		##Requires a restart.
	# Put Quickbooks into multi-user mode (File->Switch to Multi-User mode)		# Put Quickbooks into multi-user mode (File->Switch to Multi-User mode)

Codeman at 22:27, 11 November 2014

2014-11-11T22:27:47Z

← Older revision		Revision as of 17:27, 11 November 2014
Line 124:		Line 124:
	* The payments should be deposited funds. To check that go to Char to Accounts >> ITrack Sales >> Banking >> Make Deposit >> Undeposited Funds, and the payment amount should show in there.		* The payments should be deposited funds. To check that go to Char to Accounts >> ITrack Sales >> Banking >> Make Deposit >> Undeposited Funds, and the payment amount should show in there.
	* Make sure you void out the invoice and payment you pushed over - both in ITrack and in QuickBooks.		* Make sure you void out the invoice and payment you pushed over - both in ITrack and in QuickBooks.

			== Check for previous invoices inside of QuickBooks ==
			* QuickBooks has the ability to invoice out of it, but once ITrack is integrated with it, that feature becomes useless in QuickBooks. However, we don't want duplicate invoice numbers inside of QuickBooks.
			* QuickBooks does allow you to use invoice numbers multiple times, but it is much less confusing if you do not do that.
			* To find the highest invoice number in QuickBooks go to Reports >> Custom Reports >> Transaction Detail, then set the Sort By to 'Num' in descending order. Next, in the Filters tab change the filter to 'TransactionType' and select 'invoice' in the drop down field.

	[[Category:Integrations]]		[[Category:Integrations]]

Spatras: /* Synching up Tax Types */

2014-05-14T21:03:24Z

Synching up Tax Types

← Older revision		Revision as of 16:03, 14 May 2014
Line 106:		Line 106:

	=== Synching up Tax Types ===		=== Synching up Tax Types ===
	* Now ~~that~~ we ~~have the Config tab all set~~ up~~, we can push over~~ tax types~~, or rather synch them up~~ with what is in QuickBooks.		* Now we can synch up our tax types with what is in QuickBooks.
	* Back on the "Other" tab in the QuickBooks Screen in ITrack you will notice that the tax types went from being gray to being a solid black color. Unfortunately, if you try to export them you will receive errors. Instead you will need to enter those tax types into QuickBooks (if they are not already there), then synch the tax types.		* Back on the "Other" tab in the QuickBooks Screen in ITrack you will notice that the tax types went from being gray to being a solid black color. Unfortunately, if you try to export them you will receive errors. Instead you will need to enter those tax types into QuickBooks (if they are not already there), then synch the tax types.
	[[File:ExportingTaxTypes.png]]		[[File:ExportingTaxTypes.png]]

Codeman: Updated info about QuickBooks integrations

2014-03-31T21:17:23Z

Updated info about QuickBooks integrations

← Older revision		Revision as of 16:17, 31 March 2014
Line 93:		Line 93:
	* '''YOU WILL NEED TO CHECK WITH THE COMPANY ACCOUNTANT/BOOKKEEPER TO COMPLETE THIS SECTION'''		* '''YOU WILL NEED TO CHECK WITH THE COMPANY ACCOUNTANT/BOOKKEEPER TO COMPLETE THIS SECTION'''
	* This is the internal accounting principles that the specific customer runs by, you can not assume that it will be the same for every yard, so be very careful here. Even so, here is a general idea of what you are looking for on the Config tab:		* This is the internal accounting principles that the specific customer runs by, you can not assume that it will be the same for every yard, so be very careful here. Even so, here is a general idea of what you are looking for on the Config tab:
	** Part Type Income Account: ~~Something~~ 'Sales' ~~related~~.		** Part Type Income Account: Inside of QuickBooks, create a new Income Account called 'ITrack Sales' and make it a subaccount of the main Income Account. After 'ITrack Sales' is created then assign it to the Part Type Income Account in ITrack. <h6><font color='red'>[Needs more in-depth steps of how to do this]</font></h6>
	** Part Type Expense Account: ~~Something to do with how the company counts parts as an expense. Possibly 'Resale Items' or some such nonsense~~.		** Part Type Expense Account: This is not really used, you can leave it blank.
	** Tax Type Vendor: The Vendor that tax types should be associated with. Probably the IRS or State Revenue Service.		** Tax Type Vendor: The Vendor that tax types should be associated with. Probably the IRS or State Revenue Service, if the accountant does not want to use that, then you can create a vendor called 'Sales Tax' in QuickBooks and assign it to the Tax Type Vendor in ITrack. <h6><font color='red'>[Needs more in-depth steps of how to do this]</font></h6>
	** Credit Memo Account: ~~Something related~~ to ~~'Accounts Receivable'~~.		** Credit Memo Account: The bank that the company goes to.
	** Payment Account: ~~Something related to '~~Accounts Receivable'.		** Payment Account: Use the Accounts Receivable account. <h6><font color='red'>[Show where that is at in QuickBooks]</font></h6>
	** Check Bank: The bank that the company goes to.		** Check Bank: The bank that the company goes to.
	** Check Account: ~~Something related to '~~Accounts Receivable'.		** Check Account: Use the Accounts Receivable account like the Payment Account.
	** Invoice Other: ~~Probably~~ the Misc. Part Type that we pushed over earlier.		** Invoice Other: Assign this to the Misc. Part Type that we pushed over earlier.
	** Invoice Account: Something related to 'Accounts Receivable'.		** Invoice Account: Something related to 'Accounts Receivable'. <h6><font color='red'>[Needs better instructions]</font></h6>

	{{Tip\|Payments exported to QuickBooks get sent to the "Undeposited Funds" account, even if the account is renamed to something else.}}		{{Tip\|Payments exported to QuickBooks get sent to the "Undeposited Funds" account, even if the account is renamed to something else.}}
Line 121:		Line 121:
	* After selecting the invoices and payments that you want to push over, click the 'Export' button.		* After selecting the invoices and payments that you want to push over, click the 'Export' button.
	[[File:ExportInvoicesAndPayments.png]]		[[File:ExportInvoicesAndPayments.png]]
	* Inside of QuickBooks you can verify that the invoices and payments made it over by clicking on the 'Customer' button at the top toolbar inside of QuickBooks, then selecting the customer from the list. The invoices and payments should be in the results area.		* Inside of QuickBooks you can verify that the invoices and payments made it over by clicking on the 'Customer' button at the top toolbar inside of QuickBooks, then selecting the customer from the list. The invoices and payments should be in the results area.
			* The payments should be deposited funds. To check that go to Char to Accounts >> ITrack Sales >> Banking >> Make Deposit >> Undeposited Funds, and the payment amount should show in there.
			* Make sure you void out the invoice and payment you pushed over - both in ITrack and in QuickBooks.

	[[Category:Integrations]]		[[Category:Integrations]]

Jmckinstry at 22:19, 20 September 2013

2013-09-20T22:19:10Z

← Older revision		Revision as of 17:19, 20 September 2013
Line 122:		Line 122:
	[[File:ExportInvoicesAndPayments.png]]		[[File:ExportInvoicesAndPayments.png]]
	* Inside of QuickBooks you can verify that the invoices and payments made it over by clicking on the 'Customer' button at the top toolbar inside of QuickBooks, then selecting the customer from the list. The invoices and payments should be in the results area.		* Inside of QuickBooks you can verify that the invoices and payments made it over by clicking on the 'Customer' button at the top toolbar inside of QuickBooks, then selecting the customer from the list. The invoices and payments should be in the results area.

			[[Category:Integrations]]

Codeman: Info about which account in QuickBooks that payments from ITrack Pro hits

2012-12-31T22:47:59Z

Info about which account in QuickBooks that payments from ITrack Pro hits

← Older revision		Revision as of 17:47, 31 December 2012
Line 102:		Line 102:
	** Invoice Other: Probably the Misc. Part Type that we pushed over earlier.		** Invoice Other: Probably the Misc. Part Type that we pushed over earlier.
	** Invoice Account: Something related to 'Accounts Receivable'.		** Invoice Account: Something related to 'Accounts Receivable'.

			{{Tip\|Payments exported to QuickBooks get sent to the "Undeposited Funds" account, even if the account is renamed to something else.}}

	=== Synching up Tax Types ===		=== Synching up Tax Types ===