Categories
Customer Center Customers Customers Center Invoice

how to send an invoice late payment reminder to your customers

QuickBooks Online – how to send an invoice late payment reminder to your customers





FREE Trial
USA
CANADA

XERO - Alternative to QuickBooks

SAGE 50 Accounting

Limited Time Offer—Save Up To 37% On Sage 50 Accounting Software!

QuickBooks Online - Buy now and save 50%


Categories
Customers Vendors

Can I change the default A/R or A/P account in QuickBooks Online

Can I change the default A/R or A/P account in QuickBooks Online
QuickBooks Help
QuickBooks Online (QBO) is not designed to work with multiple Accounts Receivable (AR) and Accounts Payable (AP) accounts. The initial AR and AP accounts, or those selected during conversion, will be the default accounts. We encourage our customers to merge their accounts payable and receivable accounts. For more information on merging accounts, please see Merging accounts, vendors, or customers. If division of open payables and receivables are needed use one of the following options…

 

FREE Trial
USA
CANADA

XERO - Alternative to QuickBooks

SAGE 50 Accounting

Limited Time Offer—Save Up To 37% On Sage 50 Accounting Software!

 






Categories
Bank Deposit Banking Customers Receive Payment

I have already received payments in QBO from multiple customers. How to make them match with a single deposit I see in my bank feed.

You’ve two ways to match with bank feed deposit.

1) Match it directly from the bank feed downloaded transactions.

Select a row for deposit in question. The row expands to show you “Find other matching transactions” button. Once you click this button, you will see a long list of possible match transactions. To easily locate your deposits, change payment date as you’ve recorded. Select payments (type = payment) to match with bank feed deposit amount. Make sure difference is zero. Save. Done.

find other matching transactions1
find other matching transactions1

2) Manual. This will take few steps, but you will see green MATCH sign once done.
a) Go back to “Receive Payment” (create+ sign > customer > receive payment > upper left corner clock, locate payment) screen for customer payment you’ve already recorded and change Deposit to: “Undeposited Funds” instead of a bank account. Do the same for other customer payments that you want to match to a batch deposit.
b) Bank Deposit (create + sign > other > bank deposit) – check existing payments from the list to match batch bank deposit. Make sure to check correct bank account if you’ve multiple bank accounts. Save. Done. Save and Close.
c) Go back to banking center (bank feed) and now you should see green Match sign for that deposit. Click Match. It should disappear from the list.

Note: #2 is recommended process in QBO if you’ve merchant card payments or use bank deposit slip from depositing checks from various customers.

If you found our answers useful then please contribute few bucks to support this forum. Thank you!





Thank you!






Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada








Categories
Bill Invoice QBO QuickBooks Vendor Vendors

How do I fix unapplied cash payment income and unapplied cash bill payment expense

You may see two accounts for UNAPPLIED cash payments if you report Profit and Loss on a cash basis. It will automatically trigger to these two accounts simply because you have entered certain deposit and payment transactions differently than normal flow in QBO.

These two accounts are automatically added to the Chart of Accounts when the new company file is created. You can’t delete or change these two accounts.

Here is the main reason that will trigger these two account types in QBO:

  • Triggers “Unapplied Cash Payment Income” when the date of the customer deposit date is before the invoice date it’s applied to.
  • Triggers “Unapplied Cash Bill Payment Expense” when the date of the vendor payment date is before the bill date it’s applied to.

Example of “Unapplied” Customer Deposit and Vendor Payment transactions

unapplied deposit
unapplied deposit
unapplied check
unapplied check
bank register
bank register
cash basis unapplied pnl
cash basis unapplied pnl

Changing “Invoice” and “Bill” dates to be prior to payment dates should work for most transactions in this account. However, there may be other unknown circumstances where the issue may not be easily fixed. In that case, you will need to analyze each transaction and resolve the matter. Or get help from the expert.

invoice
invoice
receive payment
receive payment
bill
bill
bill payment
bill payment
cash basis applied pnl
cash basis applied pnl

 


This video will show how to fix “Unapplied Cash Payment Income” and “Unapplied Cash Bill Payment Expense” on a cash basis Profit and Loss report.

 


OTHER HELPFUL LINKS:
(Also, refer to IRS Publication 538 Constructive Receipt of Income for more details.)
https://www.irs.gov/publications/p334/ch02.html
What’s Unapplied Cash Payment?
https://community.intuit.com/articles/1146009-what-s-unapplied-cash-payment

 


If you found our answers useful then please contribute few bucks to support this forum. Thank you!





Thank you!





Sign up QuickBooks USA

Categories
Customer Center Customers

How to transfer from one customer outstanding balance to another customer credit balance

It assumes one has an outstanding balance and another one has a credit balance.

You will need to create a new dummy bank account to handle the transfer. This tutorial video will show step-by-step instruction on how to handle such transactions in new QuickBooks Online. You will need to watch the video in its entirety to fully understand the complete process involved.

 

How to transfer from one customer outstanding balance to another customer credit balance

 

If you found our answers useful then please contribute few bucks to support this forum. Thank you!





Thank you!






Sign up QuickBooks USA

 
helpful videos

 

Categories
Bank Deposit Bank Register Banking Customer Center Customers QuickBooks Payments

How do I see if a customer/client has paid their invoice by credit card in new QuickBooks Online?

How do I see if a customer/client has paid their invoice by credit card in new QuickBooks Online?

Intuit QuickBooks Payments Login Screen
Intuit QuickBooks Payments Login Screen

Assuming you have opened merchant services with Intuit QuickBooks payment account, to check and verify the customers credit card payments you’ve received

You can visit

https://merchantcenter.intuit.com

  • Go to Activity
  • Select Reports
  • Select Deposits
Categories
Company Gear Company Settings Custom Form Styles Customer Center Customers Invoice

We need to pay Sales Commissions based on Sales Invoices paid date. How to run a Customer Sales report that will tell me exactly what invoices were paid in a specific date? 

To do this job, you can run “Sales by Customer Summary” report.
You will need to customize the report to show daily sales and change to cash basis.
If you are using custom fields for sales rep on the Invoice, you can match the sales by Sales Rep as well.
See attached screenshot photo1, photo2 and photo3 for reference.

qboe-customize-sales-summary-by-days1
qboe-customize-sales-summary-by-days2
qboe-customize-sales-summary-by-days3