Categories
Custom Form Styles Invoice

How to add account summary on an invoice

The Account Summary can be added to the middle of the invoice. It includes:

  1. Balance Forward: the total amount due before this new invoice
  2. New charges: the current invoice amount
  3. Total Amount due: Balance forward plus current invoice amount

To turn on the Account Summary:

  1. Open an invoice form. (you can open new invoice or already saved invoice).
  2. Choose the customize Gear icon on the invoice (at the upper right corner).
  3. Click “Customize what your customers see” at the bottom.
  4. Switch to “Content” tab from default “Design” tab.
  5. Click the pencil on the right to edit account summary (next to amount).
  6. Now on the top left panel, check “Show on invoice” box for account summary under Table
  7. Save and Exit.

SEE SCREENSHOTS BELOW.
Note: If the customer has no balance forward from previous open invoices, then Account Summary will not show. Example: Customer’s first invoice.






 


QuickBooks Online - Buy now and save 50%



FREE Trial
USA
CANADA

XERO - Alternative to QuickBooks

SAGE 50 Accounting

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


 

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
Customer Center Customers Customers Center Invoice Sales Transactions Sales

When you send an invoice to a customer and also carbon copy (cc) it to someone, will it show viewed if either person looks at the invoice or just the primary recipient

It will show as viewed whoever viewed it (primary or cc). If it’s viewed by both it will show as viewed twice.

Viewed Status Icon: If you open sales transactions (left navigation bar > transactions > sales) under status column, it will show many have opened the invoice and viewed it. It will show one black icon if viewed by one person or two black icons if viewed by both. See attached screenshot.

(Note: In case, you do not see Status column and need to add, go to middle Gear at the far right and select show more and add status column).

sent-invoice-viewed-status

Invoice Activities: Open the invoice in question from the sales transactions or directly from customer center. Under activities (below invoice balance due, next in line to attachments), it will show invoice viewed with date and time record. But it is not possible to identify who actually viewed it (primary or cc person), especially if viewed by just one person unless one or both replied with the message. See attached screenshot.

sent-invoice-viewed-activities






Categories
Bank Deposit Customers Expense Expenses Invoice Reports

Why mark it billable to a customer and select “track returns for customers” box on a bank deposit

This has to do with reflecting accurate direct expenses related to customers on Income by Customer Report.

If you are depositing a vendor/supplier refund for an expense that was previously Billed to a customer, select “Track returns for customers” box and choose that same customer on the deposit and mark it Billable.

For example, if you buy a material for a customer’s job, you would bill the expense to the customer. But if the customer later returns the material to you and you return it to the vendor/supplier for a refund that you are depositing, you need to mark the deposit billable to that same customer and also select “Track returns for customers” box. Otherwise, it will show as customer billed for the material expense, and the vendor credit will not appear on Income by Customer Summary Report.


 





 
Here is an example of what happens when $1,000 billable purchase returned to the supplier for a refund and deposited that money in the bank. The goal is to show zero expense related to that customer.

SHOWING RESULT WITHOUT BILLABLE AND RETURNS FROM CUSTOMERS

deposit without billable-and track returns for customers
deposit without billable-and track returns for customers
income by customer summary without billable track returns from customers
income by customer summary without billable track returns from customers

SHOWING RESULT WITH BILLABLE AND RETURNS FROM CUSTOMERS

deposit with billable and track returns for customers
deposit with billable and track returns for customers
income by customer summary with billable track returns from customers
income by customer summary with billable track returns from customers

 
WATCH VIDEO
QuickBooks Online Plus: Track returns for customers box on Deposit Form


 





 

Categories
Bank Register Customers Invoice Receive Payment

How do you apply customer payment that has a merchant fee to an invoice in QBO?

You will need to group both your deposit and fee together so your deposit in QBO matches the bank deposit that was made in real life.

Here’s how to handle it in QBO at this time:

RECEIVE PAYMENT

  1. Create an Invoice for your customer as you normally would.
  2. From the home page screen, click the Create icon (+) when you’re ready to receive the payment from your customer.
  3. Choose “Receive Payment” from the dropdown that appears.
  4. Fill out the Receive Payment as you normally would, but ensure the Deposit to field reads “Undeposited Funds” account.
  5. Click Save and close.
receive payment deposit to uf
receive payment deposit to uf

 

BANK DEPOSIT

  1. From the home page screen, click the Create icon (+) when you’re ready to get the deposit, minus the fee, in your bank account.
  2. Choose Bank Deposit (under Other) from the drop-down that appears.
  3. Check off the payment from this customer (and any other payments in the batch).
  4. In the Add New Deposits area, enter in the fee as a negative number, so it reduces the overall deposit total.
  5. Click Save and close.
payment minus fee
payment minus fee

This will then match the deposit made to your bank account and record the proper account.

 

WATCH VIDEO

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
Create Customers Invoice

How do I add additional billable time and expense to an already created current invoice

In order to add additional unbilled time and expense, first open existing invoice. You can open it directly from the create + sign, select invoice under customers, and from upper left corner select invoice in question to open from the recent transactions. You can also open directly from the customer’s page under customers center.

Once the invoice is open, you will take the following steps:

1) Go far to the right corner of the invoice column and choose delete trash icon. See attachment below.
2) New Unlink the billable message screen will open. Select “Yes, unlink it” blue button. See attachment below.

unlink billable
unlink billable

3) Now “Add to Invoice” will open on the right-hand window panel. Select “Add all” or “Add” single billable item as needed. See attachment below.

add to invoice billable
add to invoice billable

4) Review and make other field changes if needed. Save. See attachment below.

new invoice
new invoice

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





Thank you!






Sign up QuickBooks USA

Categories
Create Customers Estimate Invoice Receive Payment Sales Receipt

Is there a way to create a sales receipt from an estimate

QBO is not set up to go from Estimate to Sales Receipt at this time. Currently, you create Estimate and then “copy estimate to invoice” to create an Invoice. There is no partial copy so it’s done just one-time. You receive payment against that invoice.

Workaround steps from Estimate to Invoice may also work as faster as creating from Estimate to Sales Receipt approach. Follow these steps, it may work as an alternative to Estimate to Sales Receipt.

1. Create Estimate (create + sign > customers > estimate)
estimate1
 
2. Copy to Invoice (either directly from estimate or from invoice form by selecting a customer)
invoice1
 
3. Select “Save” (bottom right, blue bottom) Invoice
invoice2
 
4. Once saved the invoice, you will promptly notice “Receive Payment” button added at the upper right corner. Click “Receive Payment” link.
invoice3
 
5. Receive Payment against the invoice. Done.
invoice4
 

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





Thank you!






BUY QuickBooks Online - Anytime, Anywhere. Easily Track Sales, Bills and Expenses.
Beach Vacation Rentals under $100 a night
Save on Smartphones from Verizon Wireless!
Over 4000+ STD Test Centers Nationwide. Order Testing Today!

Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada








Categories
Customer Center Customers Invoice

When I create an Invoice, how do I get the packing slip to show the shipping address

First, you will need to enable “Shipping” in the company settings.

Just follow these steps below:
1. Select Company Gear icon at the top right corner.
2. Click to Company Settings, select Sales.
3. Under “Sales form content” place, click the pencil icon and place a checkmark to the box next to “Shipping” to turn on the address.
4. Click on Save.

enable shipping

You also need to put in the customer’s shipping address in the Customer Details section for the shipping address to show in the packing slip.

You can edit your customer’s information through the steps below:

1. Click on the Customers tab on the left navigation bar.
2. Look for that specific customer and click on their name.
3. Once you’re in their account, click on “Customer Details” column.
4. Click on the “Edit button” at the far right side.
5. You can now edit your customer’s shipping address.
6. Once you’re done, click the Save button located on the bottom right corner of the screen.

(You can also add shipping address directly on the Invoice form, but that will not update customer details page)

shipping address

After doing these steps, create an invoice, select Print or Preview (at the bottom) and try to “Print packing slip”.

packing slip

At this time, PACKING SLIP is just for Invoice, it’s not available for Sales Receipt. I’d suggest sending feedback to Intuit QBO team. Just click the Gear icon (upper right corner), and click “Feedback” under Your Company.

feedback screen

Tutorial Video

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 Check Create Customers Expense Expenses Invoice Sales Receipt Vendor

How to link expenses to specific customers clients