DocuSend QuickBooks App Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Mac Forum

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 07-01-2015, 01:26 PM
jgb jgb is offline
Registered User
 
Join Date: Mar 2015
Posts: 9
Apply Imported Payments to Invoices

I imported a batch of invoices without a hitch. Later, I imported the payments for those invoices. The import form doesn't have a field for invoice numbers. After the import my customers' accounts were correct, which is good, but the individual invoices are still open. I can't even find a way to mark them as paid.

Any solutions or ideas?
Reply With Quote
  #2  
Old 07-01-2015, 05:17 PM
uniz uniz is offline
Registered User
 
Join Date: Oct 2013
Posts: 145
how do you import the invoices and the payment in batch? In general, to have an invoice paid, you have to open the payment and tick on the invoice you want to apply.
So I guess, when you import the payment, it just imports the payment itself, but not apply (link) to the invoice. To fix it, you have to open each payment and apply to the invoice.
Reply With Quote
  #3  
Old 07-02-2015, 07:57 AM
jgb jgb is offline
Registered User
 
Join Date: Mar 2015
Posts: 9
Thanks for the reply uniz. Unfortunately when you open the payment and check the invoice, QB adds the invoice amount to the payment amount, in essence double counting.
Reply With Quote
  #4  
Old 07-02-2015, 11:29 AM
uniz uniz is offline
Registered User
 
Join Date: Oct 2013
Posts: 145
Quote:
Originally Posted by jgb View Post
Thanks for the reply uniz. Unfortunately when you open the payment and check the invoice, QB adds the invoice amount to the payment amount, in essence double counting.
so, when you open the payment, did it check to the invoice already or not?
I'm not sure how it double count. Probably taking a screenshot of that window will be easier to troubleshoot.
Reply With Quote
  #5  
Old 07-02-2015, 02:24 PM
SkinnyRaven SkinnyRaven is offline
Registered User
 
Join Date: Jan 2012
Location: Anchorage, AK
Posts: 143
Quote:
Originally Posted by jgb View Post
Thanks for the reply uniz. Unfortunately when you open the payment and check the invoice, QB adds the invoice amount to the payment amount, in essence double counting.
From recieve payments see if the customer/job shows credits. If so leave the payment amount at 0.00, do not check off any invoices, and use apply credits.
__________________
Mac OS X 10.9.5
QuickBooksMacPro 2015
Reply With Quote
  #6  
Old 07-02-2015, 03:43 PM
uniz uniz is offline
Registered User
 
Join Date: Oct 2013
Posts: 145
Quote:
Originally Posted by SkinnyRaven View Post
From recieve payments see if the customer/job shows credits. If so leave the payment amount at 0.00, do not check off any invoices, and use apply credits.
check on the invoice is the same as apply credit. nothing different.
Reply With Quote
  #7  
Old 07-02-2015, 04:08 PM
uniz uniz is offline
Registered User
 
Join Date: Oct 2013
Posts: 145
Quote:
Originally Posted by jgb View Post
Thanks for the reply uniz. Unfortunately when you open the payment and check the invoice, QB adds the invoice amount to the payment amount, in essence double counting.
I think I understand what error you have.
Like I say: "open the payment" means you have to Open the customer center, navigate to that customer, and double click on the payment to open it, then check on the invoice you want to apply.

I guess what you did is that you went to the Customers menu, select "Receive payments". If you do so, you're posting a new payment, not "open the payment". So, if you post a new payment, it double pays.
Reply With Quote
  #8  
Old 07-03-2015, 07:37 AM
jgb jgb is offline
Registered User
 
Join Date: Mar 2015
Posts: 9
Payment Screenshots

To recap:
I first imported a batch of invoices, then imported a batch of payments.
From the Transaction Center I opened one of the payments (see screenshot).
I checked the invoice to be paid by the payment but as you can see from the second screenshot the payment amount doubled.

It looks like you have to either 1) enter payments manually, 2) manually change the amount after checking the invoice, or 3) live with the open invoices. Even though the first screenshot shows the unapplied amount at the bottom, the customer's account balance is $0.
Attached Images
File Type: jpg QB Payment 1.jpg (157 Bytes, 18 views)
File Type: jpg QB Payment 2.jpg (157 Bytes, 18 views)
Reply With Quote
  #9  
Old 07-06-2015, 08:20 AM
uniz uniz is offline
Registered User
 
Join Date: Oct 2013
Posts: 145
Quote:
Originally Posted by jgb View Post
To recap:
I first imported a batch of invoices, then imported a batch of payments.
From the Transaction Center I opened one of the payments (see screenshot).
I checked the invoice to be paid by the payment but as you can see from the second screenshot the payment amount doubled.

It looks like you have to either 1) enter payments manually, 2) manually change the amount after checking the invoice, or 3) live with the open invoices. Even though the first screenshot shows the unapplied amount at the bottom, the customer's account balance is $0.
I couldn't see your screenshot.
I need you to do one test: Go to Customer Center, navigate to one customer that has $0 balance, right click, select "Open Balance". From there, do you see two lines: the invoice and the payment or nothing? If there're two lines, let do this: Open the invoice, click on "Apply credits" button, and then check on the payment to apply it against the invoice.
Hope that help
Reply With Quote
  #10  
Old 07-07-2015, 07:14 AM
jgb jgb is offline
Registered User
 
Join Date: Mar 2015
Posts: 9
Thanks Uniz. I had already manually changed all the payments so I will have to wait until I import another batch.
Reply With Quote
Reply

Bookmarks
Bookmark and Share
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump


All times are GMT -5. The time now is 12:22 PM.


 

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.