{"id":448,"date":"2012-03-23T09:44:01","date_gmt":"2012-03-23T14:44:01","guid":{"rendered":"http:\/\/www.iqaccountingsolutions.com\/blog\/?p=448"},"modified":"2012-09-24T14:20:09","modified_gmt":"2012-09-24T19:20:09","slug":"apply-vendor-invoice-to-customer-balance","status":"publish","type":"post","link":"https:\/\/www.iqaccountingsolutions.com\/blog\/apply-vendor-invoice-to-customer-balance\/","title":{"rendered":"Apply Vendor Invoice To Customer Balance"},"content":{"rendered":"<p>If you have a customer that is also a vendor, you may want to apply their A\/R invoices against their A\/P balance.\u00a0 To do that, first you will need to set up a new GL account.\u00a0 Then you have a simple two step process to clear both balances.<\/p>\n<p>First, set up a dummy cash account that will be used as a clearing account.\u00a0 Go to <em>Maintain<\/em> &#8211; <em>Chart Of Accounts<\/em>. Enter a number for your new account in the <em>Account ID<\/em> field.\u00a0 I would recommend giving it a number that falls at the end of your range for cash accounts.\u00a0 Enter a description such as A\/R A\/P Clearing Account.\u00a0 Leave the <em>Account Type<\/em> set to Cash and click <em>Save<\/em>.<\/p>\n<p>Next, enter a receipt to mark the AR invoices as paid.\u00a0 Go to the <em>Tasks<\/em> menu and choose <em>Receipts<\/em>.\u00a0 Change the cash account to the clearing account you just set up.\u00a0 Enter the customer ID and check the invoices to be paid just like you would if you had received a check.\u00a0 You will need to enter something in the <em>Reference<\/em> even though there is no check number; enter something like &#8220;trade&#8221; or the AP invoice number you&#8217;re offsetting this against.\u00a0 The payment method isn&#8217;t important in this case, but if you want you could set up &#8220;Trade&#8221; as a payment method by going to <em>Maintain &#8211; Default Information &#8211; Customers &#8211; Pay Methods<\/em>.<\/p>\n<p>Finally, enter a payment to clear off the AP invoices.\u00a0 Go to <em>Tasks<\/em> &#8211; <em>Payments<em>.<\/em>\u00a0 Change<\/em> the cash account to the clearing account, enter the vendor ID, and check the invoices that you want to offset against receivables.\u00a0 You can enter a partial payment amount if needed to get the total to exactly match the amount of receipt from the previous step.\u00a0 Enter a dummy check number before saving the payment.<\/p>\n<p>The receipt will debit the clearing account and the payment will credit it, resulting in a zero ending balance.\u00a0 A non-zero balance in the clearing account <span style=\"text-decoration: underline;\">always<\/span> means that something has been entered incorrectly or is not complete.<\/p>\n<p>One important note is that both the <em>Receipts<\/em> and <em>Payments<\/em> windows remember the last cash account that was used, so be sure to change it back to your regular cash account next time you enter a transaction.\u00a0 Or, better yet, open an existing receipt and payment and resave them before closing the windows to reset the cash accounts.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you have customer that are also vendors, you may want to offset the A\/R and A\/P balances against each other.  This tip shows you how to do it easily.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/448"}],"collection":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=448"}],"version-history":[{"count":5,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/448\/revisions"}],"predecessor-version":[{"id":626,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/448\/revisions\/626"}],"wp:attachment":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}