All posts by admin

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!








2015 Laser 1099-MISC Income, Federal Copy A, Bulk

2015 Laser 1099-MISC Income, Federal Copy A, Bulk


Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada






QuickBooks UK



QuickBooks Online 30 day Free Trial



QuickBooks Australia




In setting up my new QuickBooks file, how do I enter the existing bank account balance with outstanding uncleared checks

It really depends upon how they were reported in previous year’s Financial Statement Report.

Let’s take examples and assume the ending bank balance per the bank statement is $11,000. There is also one check you wrote for $10,000 has not cleared the bank yet. In your books, the actual bank balance should be $1,000, right?

Example #1: You have already reported $10,000 as an expense in the previous year’s financial statement.

Since you have already reported, you do not want to expense it again in the current year. You would post $10,000 check as “Prior year” activity, with a prior date. This way, you can put the bank statement’s ending balance and have the uncleared check as outstanding, for the purpose of bank reconciliation.

example1_1

example1_2

example1_3

example1_4

Example #2: You have not reported $10,000 as an expense in the previous year’s financial statement.

This becomes your current year financial activity when the check has cashed the bank. If you are downloading banking transactions, you would expense it when the bank posted the transaction. In setting up QuickBooks file, the bank balance is $11,000, the same as the bank statement balance.

example2_1

example2_2

example2_3

example2_4


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





Thank you!







2015 Laser 1099-MISC Income, Federal Copy A, Bulk

2015 Laser 1099-MISC Income, Federal Copy A, Bulk

Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada






QuickBooks UK



QuickBooks Online 30 day Free Trial



QuickBooks Australia




What are the specific reports available with the Simple Start version of Quickbooks Online

First, Simple Start plan may be the best value for the bucks if your business just needs to sync bank accounts to the QuickBooks, categorize transactions to generate the Profit and Loss report; and there is no need for Accounts Payable feature.

These are the built-in standard reports available in Simple Start plan as of December 30, 2015.

simple start reports
simple start reports

Business Overview:

  • Profit and Loss by Month (NEW)
  • Quarterly Profit and Loss Summary (NEW)
  • Profit and Loss
  • Balance Sheet
  • Statement of Cash Flows
  • Audit Log

Notice there is no General Ledger (GL) report on the list. If you think you need this valuable report added to future revision, you should send them your feedback to Intuit developers.
From the home page screen > Company Gear (upper right corner) > Your Company > Feedback > Post Your Own Idea

Review Sales:

  • Sales by Customer Summary
  • Sales by Product/Service Summary
  • Product/Service List
  • Customer Contact List
  • Estimates by Customer
  • Deposit Detail

Manage Accounts Receivable:

  • Customer Balance Summary
  • A/R Aging Summary(1)
  • Collections Report
  • Invoice List
  • Statement List

(1) TIP: Notice there is no A/R Aging Detail report on the list. From A/R Aging Summary report > click grand total amount link under “TOTAL” column. It will take you to the A/R Aging Detail report. The only difference with plans is you can’t customize this report.

Review Expenses and Purchases:

  • Transaction List by Vendor
  • Vendor Contact List
  • Check Detail

Notice there is no A/P Aging Summary report listed because there is no Accounts Payable (A/P) feature in Simple Start plan.

Manage Sales Tax:

  • Taxable Sales Summary
  • Sales Tax Liability Report

Manage Employees:

  • Employee Contact List

Manage Payroll:
(Once you are subscribed to the Intuit Payroll service, you may also see the following reports)

  • Time Activities by Employee Detail
  • Recent/Edited Time Activities
  • Payroll Summary
  • Payroll Tax Liability
  • Payroll Tax Payments
  • Payroll Billing Summary
  • Payroll Details
  • Employee Details
  • Payroll Tax and Wage Summary
  • Workers’ Compensation
  • Total Payroll Cost
  • Payroll Deductions/Contributions
  • Paycheck List
  • Total Pay
  • Vacation and Sick Leave
  • Retirement Plans
  • Multiple Worksites
  • Employee Directory

Accountant Reports:

  • Account List
  • Reconciliation Reports
  • Journal
  • Profit and Loss
  • Balance Sheet
  • Exceptions to Closing Date
  • Statement of Cash Flows
  • Transaction List by Date
  • Recent Transactions

These are additional reports available with QBO Accountant version.

  • Adjusted Trial Balance (Accountants Only)
  • Adjusting Journal Entries (Accountants Only)
  • Profit and Loss Comparison (Accountants Only)
  • Balance Sheet Comparison (Accountants Only)

TIP: From Accountant version, you can UNDO bank reconciliation. Check out our article and how-to video.

My Custom Reports
You can customize many of the built-in reports and make it your own reports. Set up to automatically distribute by email. Awesome!

Management Reports
Professional set of ready-to-use management reports as prepared by accounting firms. Also, an ability to add additional built-in reports to the management reports. You can’t automate the reports at this time.

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






QuickBooks UK



QuickBooks Online 30 day Free Trial



QuickBooks Australia




Owner paid a subcontractor with his own money. How to make sure Vendor shows up on 1099 and still able to write the reimburse check to the Company Owner

First, you will need to create a new dummy bank account. You will also need a due to the owner as a liability type account to use it for later reimbursement.

Step#1 Use bank deposit form (create + sign > other > bank deposit) to record contributed amount by the owner to pay a contractor. Account to show as due to the owner liability type account. See screenshot below.

owner deposit
owner deposit

Step#2 Use Expense form (create + sign > vendor > expense) to create contractor expense posted to appropriate expense account. See screenshot below.

contractor expense
contractor expense

Step#3 Use Check form (create + sign > vendor > check) to write the reimburse check to the Company Owner. See screenshot below.

check to owner
check to owner

In case there is no need to reimburse the owner (step#1), you will use a capital contributed account which would be an Owner’s Equity type account.

Review of 1099 vendors and payments list. See screenshot below.

review 1099 vendors payments
review 1099 vendors payments

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





Thank you!








2015 Laser 1099-MISC Income, Federal Copy A, Bulk

2015 Laser 1099-MISC Income, Federal Copy A, Bulk


Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada






QuickBooks UK



QuickBooks Online 30 day Free Trial



QuickBooks Australia




How to handle when a customer has an overpayment in account balance and goes out of business

Accounting treatment in QuickBooks is exactly the same like when Vendor goes out of business prior to payment for the open balance.

If the vendor (or customer with a credit balance) goes out of business due to bankruptcy, keep it until you hear from the courts with instructions as to where to forward your payment.

In case, you do not hear from the courts (depending upon regulations in your state, you may have to leave it on the books for several years, in many states for up to 5 years), you will reverse the entry by creating a credit memo and take it as income like the one-time gain to your P&L.

If you are really interested in clearing A/P or A/R (negative balance), you can also set it up as holding liability account on your Balance Sheet.


 

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





Thank you!








2015 Laser 1099-MISC Income, Federal Copy A, Bulk

2015 Laser 1099-MISC Income, Federal Copy A, Bulk


Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada






QuickBooks UK



QuickBooks Online 30 day Free Trial



QuickBooks Australia




There was a new employee missed paycheck. How to make a new payroll check after payroll has already been run and printed

It is very easy to run a new paycheck. To run a payroll for one of your Employees, you can follow these steps:

  • From the home page screen, go to Employees on the left navigation bar.
  • Click Run Payroll on the upper right-hand corner.
  • Change the Pay Period (see attached screenshot below) and Pay
  • Date indicated to the previous payroll date.
  • Check the box next to the Employee that you’ll be paying, and enter its payment for that period.
  • Click Preview Payroll on the lower left-hand corner to check the amounts calculated.
  • Click Print Paychecks at the top of the Employee List table to print it, and then click Finish Payroll.

Note: You can also add “New Employee” from “Run Payroll” screen. See attached screenshot below.

run missed paycheck

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






QuickBooks UK



QuickBooks Online 30 day Free Trial



QuickBooks Australia




How to create bonus on my employee’s paycheck in QBO Payroll

There are two ways to create bonus paycheck to your employee in QBO Payroll.

1) Regular Payroll Check
2) Separate Payroll Check

Here are the steps to create a bonus with a regular paycheck:

  • On the left panel, click the Employees tab.
  • Select an employee you wish to add this pay type.
  • Click on the Pencil icon next to pay.
  • In Section 3, click on Add additional pay types.
  • Select Bonus and click Done.
  • Once you run payroll, you’ll see a box where you can enter the bonus amount.

bonus1

Here are the steps to create the bonus separate from the paycheck:

  • On the left pane, click the Employees tab.
  • Click the Run Payroll drop-down arrow and select Bonus only.
  • Select As gross pay (this will deduct taxes accordingly).
  • Enter the pay date.
  • Select the name of the employee that will be receiving the bonus check with the checkbox to the left of their name.
  • Enter the amount in the Bonus field.
  • Click Preview Payroll
  • Click Submit Payroll

bonus2


Tutorial Bonus Paycheck 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






QuickBooks UK



QuickBooks Online 30 day Free Trial



QuickBooks Australia




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






QuickBooks UK



QuickBooks Online 30 day Free Trial



QuickBooks Australia




Our top 10 QBO improvements list of 2015

1. Permanently delete-excluded bank transactions
2. Mark a bank transaction as a billable expense and assign it to a customer
3. Collapse the left navigation bar
4. Multi-currency support
5. Add custom reports to your management reports packages
6. Hide sensitive data from limited access users on Customers and Vendors pages
7. Hide account balances from “limited access” users
8. Add subtotals on invoices and estimates1
9. Copy journal entries
10. Quicker access to registers right from the home page

Top 10 QBO Improvements of 2015

QuickBooks Online – Review of 2015 top improvements, worse update, 2016 wish list