KnowledgeBase

How Does Quickbooks Apply a Customer Payment To an Invoice With Multiple Line Items?

Chief Mechanic · September 11, 2010 ·

QuickBooks applies a customer payment to an invoice with multiple line items by applying the proportion of the pre-tax subtotal paid to each individual line item and applying the remainder to sales tax on the invoice.

If an invoice is paid in full, this obviously results in every individual line item and the applicable sales tax marked as paid in full.

If the invoice is only partially paid, individual line items on the invoice will be partially paid in the proportion that the total payment bears to the pre-tax subtotal.

Let’s review an example using the sample data for Castle Rock Construction from QuickBooks 2009.

As of 12/4/2012, customer Teschner (an example name only) has 2 invoices outstanding: invoice # 1064 dated 10/5/2012 for $760 (the balance remaining) and invoice # 1085 dated 11/28/2012 for $8305.95. On 12/5/2012, Teschner makes a payment of $5000 on check # 56321. A portion of this payment, $760, is applied to the older invoice, # 1064, paying that invoice in full. That leaves $4240 (i. e., $5000 – $760) to partially pay invoice # 1085.

Invoice # 1085 contains 8 line items with a pre-tax subtotal of $7920 and sales tax of $385.95, for a total of $8305.95. To determine how QuickBooks applies the partial payment of $4240 to the line items on this invoice, compute the proportion of the payment to be applied ($4240) to the pre-tax subtotal ($7920), or 0.510477429 ($4240/$7920).

Next, multiply this ratio by the pre-tax subtotal of each line item on the invoice. The first line item has a subtotal of $600. Therefore, the amount paid on this line item is $306.28, or 0.510477429 X $600. If we continue this process for each line item on the invoice and sum the amounts paid, that total will be $4042.98. Since we started with a total of $4240 to apply to this invoice, the remainder of $197.02 (or $4240 – $4042.98) is applied to sales tax.

By creating a cash basis Custom Transaction Detail Report, we can see exactly how QuickBooks applied the payment to an invoice. We’ll use the date parameters and the Filters on the Modify Report… button to highlight the exact application of the original payment of $5000. Remember, a portion of this amount, $760, was applied to an older invoice. This appears as the second line on the report. The amounts in the debit column correspond to the exact application of the check. For invoice # 1085, the invoice with multiple line items that was partially paid with this check, the amounts in the debit column represent the payment applied to each line item on the invoice.

QuickBooks Custom Transaction Detail Report Apply Customer Payment

(0 rating, 2 votes)

Do Deposits Appear In a Center, Such As the Customer Center?

Chief Mechanic · September 11, 2010 ·

Deposits don’t appear in a Center, such as the Customer Center under normal circumstances.

The 3 Centers (Customer, Vendor, and Employee) only include transactions where the transaction source matches the Name shown in the Center. For a Deposit, a customer is not considered the transaction source. Instead, it’s the target.

Sources and targets are an important concept in QuickBooks. For more information, see our article on sources and targets.

If you record a Deposit via the Make Deposits window, the source is the bank account. Even if you enter a Name in the Received From field, that Name is associated only with targets, not the source. There’s no way to assign a source Name in the Make Deposits window.

However, if you open the Register for the bank account to which the funds were deposited, you can edit the Name assigned to a Deposit. Under normal circumstances, a Deposit could be made up of funds from multiple Names, so QuickBooks doesn’t assign a Name to the Deposit.

The first 2 entries on the screenshot below are typical deposits where no Name was assigned. The third entry is a Deposit made via the Make Deposits window but where we’ve edited the Name in the bank account register to include a Customer:Job name. This edited Deposit does appear in the Customer Center for that Customer:Job, as shown below.

While it’s technically possible to make a Deposit appear in a Center, we don’t recommend it. A Deposit made up of funds from multiple Names can never be made to appear in a Center for more than 1 Name, since only 1 Name can be assigned to the source. That makes expecting Deposits in a Center very unreliable – something that is never a good idea for an accounting system.

QuickBooks Enterprise Solutions 10 Deposit In Center

QuickBooks Enterprise Solutions 10 Deposit In Center 2

(0 rating, 2 votes)

What Are Sources and Targets?

Chief Mechanic · September 11, 2010 ·

Sources and targets are important concepts to understand reporting in QuickBooks and use of the Advanced Find function.

Sources and targets are terms assigned by Intuit to describe transactions.

In most instances, the source of a transaction is the summary or total of the transaction. For example, the source of a check includes the amount of the check, the payee, and the bank account from which the check was written. The target of a transaction is the distribution of the source into 1 or more other accounts. For example, a check might be used to pay expenses in 2 different General Ledger accounts, which appear on the Expenses tab below the check payee information. The targets of this check include the information on these 2 lines.

A transaction can have 1 source and 1 or more targets. In most instances, the source is equal to the sum of the targets. Forms or windows in QuickBooks determine what information will be the source and what will be the target. Your only control over what is the source or target is what you enter (subject to validation) in the appropriate area of the form. In the check example below, the top part of the check form is always the source, and the bottom part always contains the target information. However, don’t extend too far the thought that the “sources are on top of the form and targets on the bottom.” That only applies to A/R & A/P transactions.

General Journal Entries are one important exception to the discussion of sources and targets. The first line of a general Journal Entry is the source, and all other lines are targets. Depending on how one enters a general journal entry, the source may not be equal to the sum of the targets. Since you have direct control over the order of lines in a general journal entry, you do control what the source and targets are for general journal entries.

Payments, statement charges, and transfers don’t follow the model that the source is on the top of the form and targets on the bottom.

Here are the source and targets for QuickBooks transaction types:

Invoice: A/R is the source; income accounts associated with the line items are the targets
Bill: A/P is the source; expense accounts on the line items are the targets
Deposit: The Deposit To account is the source; the accounts on the line items are the targets
Payment: The Deposit To account is the source; A/R is the target

To learn the source and targets for any transaction, click the Journal button or use the keyboard shortcut Ctrl + Y. The source is the first line listed. The targets are the lines listed after the source.

QuickBooks Enterprise Solutions 10 Check

QuickBooks Enterprise Solutions 10 Check Transaction Journal

In this example, the source is the first line of the report that shows the payee and check amount. There is 1 target, the second line that contains the distribution information. We’ve added Source Name as an additional column to the standard Transaction Journal report to better illustrate sources and targets. Note that the Name field for the target is the Customer:Job name, but the Source Name is the check payee. Reports that show target information won’t show the check payee in the Name field.

That leads to confusion among QuickBooks users that aren’t familiar with sources, targets, and the type of information that appears on a report. A report that shows check information in an expense account is reporting target information. The report is not indicating that a check was written to the information shown in the Name field.

According to Intuit:

sources and targets are database concepts and have nothing to do with debits or credits
a source can be a debit or credit, just as a target can be a debit or credit
most reports display a mixture of source and target data
the Inventory Valuation Summary and Inventory Valuation Detail reports are examples of exceptions in that they display only target data

This Intuit knowledge base article offers additional information on sources and targets. When reading it, don’t forget the general journal entry exception to statements about sources and targets. Some of the statements in Intuit’s own materials don’t repeat that exception, and they’re only true with that exception noted.

Issues involving confusion about sources and targets are fairly common. To address these issues, Intuit also offers explanations of the source and target data sets, the report set, where reports get their data, and how conflicting report filters produce unexpected results.

(+4 rating, 4 votes)

How Do I Choose the Adjustment Account When Adjusting Inventory Quanity or Value On Hand?

Chief Mechanic · September 11, 2010 ·

The adjustment account you choose depends on why you need to adjust inventory and how much detail you want in your GL.

Quantity adjustments can occur as a result of several common business situations, such as theft or discovery of damaged goods that have become unsaleable. If you want a great deal of detail in your GL, you can create adjustment accounts for each type of adjustment.

Typically, the adjustment account you enter will be an expense account for negative adjustments; for positive adjustments, you may want to choose an income account. Unless your general ledger has different accounts for different types of inventory variances, such as defects and shortages, we recommend assigning all inventory adjustments to the same GL account to provide for consistent reporting and to simplify tracking transactions.

In the screen shot below, we’ve selected GL account # 69000, Miscellaneous expenses. However, this account selection won’t provide much detail to allow us to manage inventory adjustments at the financial statement level. If your inventory adjustments are frequent enough or material enough, you may want to create a separate expense account for inventory adjustments. For even more detail, that account could have multiple sub-accounts. Adjustments would be recorded to these sub-accounts based on why inventory was adjusted.

QuickBooks Premier 2009 Inventory Adjustment for Quantity On Hand

When you enter a negative quantity adjustment, the inventory asset account (shown on the Edit Item window) for the item you are adjusting is credited (i. e., decreased), and the expense account that you entered as the adjustment account is debited (i. e., increased). For positive adjustments, the debits and credits are reversed. Both Profit & Loss and Balance Sheet accounts are affected by inventory adjustments.

In QuickBooks, while the Adjust Quantity/Value on Hand window is selected, you can press Ctrl + Y to display the Transaction Journal of the debits and credits entered.

QuickBooks Premier 2009 Transaction Journal Negative Inventory Quantity Adjustment

Keep in mind that for each adjustment, you can choose only 1 adjustment account or enter 1 memo. You can also enter a Customer:Job or Class. Therefore, you’ll need to group your adjustments based on why you’re making the adjustment.

The debits and credits of value adjustments behave the same as quantity adjustments. Typically, there’s a different reason for a value adjustment. The most common is discovery of a value impairment. In other words, the firm still has the same quantity of an item on hand, but because of changed market conditions or the passage of time, the value of those units has declined. Switching from the default quantity adjustment to a value adjustment is accomplished by checking the Value Adjustment checkbox in the lower left of the Adjust Quantity/Value on Hand window.

Quantity adjustments to fix on hand levels that have become negative are a special circumstance of inventory adjustments. Because QuickBooks uses the average cost method, the impact on accounts from allowing inventory levels to go negative can be far reaching. To gain a better understanding of the impact, read our blog post on the subject.

(+2 rating, 2 votes)

What Does Error Code 6130 Mean?

Chief Mechanic · September 11, 2010 ·

According to Intuit, Error Code 6130 indicates that QuickBooks couldn’t disconnect from the computer on which the QuickBooks company file is located. It occurs when QuickBooks is operating in multi-user mode.

The file path at which QuickBooks expects to find the company file is the location shown on the Product Information screen. This screen can be displayed by pressing F2 while in QuickBooks.

QuickBooks Premier 2009 Product Information Location

For more information on resolving Error Code 6130, consult this Intuit knowledge base article.

(No Ratings Yet)

KnowledgeBase

Accounting

Developer

Intuit