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!

 






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

How should I really enter refund by a Vendor in new QuickBooks Online?

I followed the refund by a vendor. I entered as a deposit. But then it does not show in the vendor’s transaction listing. How should I really enter this type of transaction?

At this point, they do not have have any designated way to record this transaction. It is just work-around approach to show in the Vendor Center’s transaction listing.

#1 Create Vendor Credit
From the home page screen

  • Select “Vendor Credit” tab under Vendors heading
  • Choose a vendor
  • Make sure account selection (that be entered as account for credit entry) is the same as original account. This is to show applying credit to the same account. For example, you bought printer and expensed it to Computer Expense account . Returned it and received refund for the returned item. Use the same account to credit the refund from the vendor.

#2 Show Bank Deposit for Refund
From the home page screen

  • Select “Bank Deposit” tab under Others heading
  • Choose Bank account for deposit
  • Received From = Name of Vendor from the drop down list who gave you refund
  • Account = Accounts Payable from the dropdown chart of account
  • Amount = refund amount deposited to the bank
  • Enter other related information
  • Save

#3 Unncessary extra step but got to do it

GO back to Vendors Center (blue navigation bar > Vendors > Locate specific Vendor), you will notice “1 Open bill” message under Pending Bills for that Vendor. This could be flawed in QBO design at this time.

  • Select “Make payment” button under “Action” column
  • New “Bill Payment” screen will open
  • You will notice in and out with zero amount transaction
  • Change Ref number to “blank”
  • Save and Close

“1 Open Bill’ message is gone now.
Again, this is unncessary step in new QuickBooks Online.

How should I really enter refund by a Vendor in new QuickBooks Online QBO

How do I record negative (credit) Vendor (Supplier) Bill in new QuickBooks Online?

Vendor Credit Form
Vendor Credit Form

How do I record negative Vendor bill?
If it’s for vendor’s (or supplier’s) credit bill:

  • Click Create “+” sign in the middle (see attached screenshot below for reference)
  • Select “Vendor Credit” under Vendors
  • It will leave credit balance on Accounts Payable under Vendor’s Name.
Vendors Credit
Vendors Credit

New QuickBooks Online Plus – How to enter various expenses in new QBO?

QuickBooks Online (QBO) Tutorial – Customer Invoice, Sales Receipt, Receive Payment, Bank Deposit