Optional Modules > QuickBooks Connector > QuickBooks Desktop > Configuring the Connector | Defaults Item Tab

Defaults Item Tab

You should have your accountant review all configuration settings prior to going live with the Connector.

Defaults Item Tab

In this section we will discuss each section of the Defaults Item Tab.

 

clip0498

 

 

 


Sub Charges

clip0499

 

The sub charges are set up in the Setting Tab in the System Preferences section. In the screen shot above you will use the pull down menu to the right of each sub charge to indicate the appropriate QB Item.

If the QB item you need does not appear in the pull down list, then you will need add it to QBooks, then click the Pull Data from QuickBooks button

 

The QB Item will determine if the sub charge is taxable or not.

If the markup for the sub charge is taxable, then click on the checkbox to the right. For example, often freight is not taxable, but the markup for freight is.

 


Client Deposit Settings

 

clip0500

 

Item for Merchandise Deposits  

1.        Set up a Other Current Liability account called:  Client Merchandise Deposits.

2.Set up an Item, type Other Charge , "Merchandise Deposits”.  Set as Non Taxable. Assign the Client Merchandise Deposits account to this item.

 

Item for Services Deposits   (do this only if your firm received retainers for your services)

1.        Set up a Other Current Liability account called: Client Services Deposits or Client Retainer Deposits.

2.Set up an Item, type Other Charge, "Services Deposits”.  Set as Non Taxable. Assign the Client Services Deposits account to this item.

 

Payment Method

In QBooks go to Lists > Customer & Vendor Profile Lists. Then click on Payment Method List.

Add a Payment Method called DS Deposit  and assign it to type Check.

 

How DS Deposit can be used:

Most DesignSmart clients will not use this feature, but it will be explained in brief here:

Within QBooks you can use the Customer Payment feature to apply some, or all, of the client's deposit to an outstanding invoice. When you do this you will need to use the payment method of "DS Deposit" (or whatever you named it).

Then you will be able to "Pull invoice Payments" down from the Invoices Layouts in DesignSmart and the invoice will be properly updated with this additional payment.


 

Invoice Journal Entry

 

clip0501

 

When you apply a client deposit to an invoice, DesignSmart will automatically create a journal when the invoice is pushed to QuickBooks. The reason for this entry is that if you receive the client deposit during one tax period, but apply the client deposit to an invoice in another period,

then the Sales Tax Liability report will only be partially correct. The sales tax liability will be  correct, but the Taxable Sales and Non Taxable Sales columns will be wrong.  

In order for the Sales Tax Liability report to be accurate, it is necessary to make a journal entry to move the amount of the deposit applied to the invoice from the liability account to an asset account.  

Again, DesignSmart will automatically create the journal entry for you, but you first must take the following steps.

 

Note: the steps below may vary depending on the advice of your accountant.

Step 1  Set up an “Other Current Asset” account. For this guide, we will call it “Payment by Client Deposit”

Step 2   Set up a QB Item of the type “Payment”. In the image below it is called “Client Deposit Applied”. Be sure to click the “Deposit To” button and select the Other Current Asset you selected in the step above.

 

clip0502

 

Step 3 Pull down the Items from QuickBooks and in the box below, select the payment item you set up in Step 2 in the area shown below.

clip0501

 

The image below shows an invoice for and the journal entry that DesignSmart automatically created when the $1,000 of deposit funds was applied to the invoice.

clip0503


 

Purchase Order Setting

         In order for DesignSmart to push an purchase order to QuicBooks Online, it is necessary to indicate your Accounts Payable account below.

clip0745

 


Vendor Deposits Settings

         Create an Other Current Asset account called Vendor Deposits Prepaid (or the name of your choice).

         When you enter a vendor deposit in DesignSmart you will indicate if it is to be paid by check or credit card. When the deposit is pushed to QuickBooks it will add an entry to the appropriate check register or credit card register.

         In addition, the payment will be recorded in the Vendor Deposits Prepaid Account.

clip0746


Time Tracking Default

The default timesheet service items will be appear by default when you create a timesheet.

 

clip0632

 


 

Miscellaneous Items

The items in this area are rarely used, but need to be setup since the circumstances in which they are used can occur on rare occasions.

clip0504

 

Adjustment When sub-charges are included in the price of the item, or when component items are included in the price of the primary item, the total price shown on a proposal or invoice can differ slightly from the total of the line items. When this happens, DesignSmart will send the "Rounding Adjustment" to QuickBooks using the Item assigned to this term. Typically these adjustments are just a few pennies. This QB Item must be set to non-taxable. For more information click here.
Markup for taxable items We recommend that you create an item with this name or use an "other" or "miscellaneous" item. It is important that this item be set as Taxable in QBooks. As for why you need this item, please read Those Crazy Taxes.
Markup for non-taxable items We recommend that you create an item with this name or use an "other" or "miscellaneous" item. It is important that this item be set as Non-Taxable in QBooks. As for why you need this item, please read Those Crazy Taxes.

 



© 2024 DesignSmart | All rights reserved. | TheSmartDesigner