Categories
Company Settings Customer Center Customers Settings Statement

I recently went to the new quickbooks online. How do I create a billing statement of open items to send to my customers like I used to do easily before?

From the Homepage screen

      Click “+” sign (top middle)
      Select “Statement” under Other header
Statement
Statement

How to email statement to a customer?

      Select “Edit” under Delivery Method column
      Default could be “None” 
      Select “Email” from the pop up screen and follow the instructions
      Select “Create/Send Selected Statements” button
      It will send email and will end with “Statements Created” message report.
Statement Delivery Method
Statement Delivery Method
Statement Choose Type
Statement Choose Type
Statement Delivery Email
Statement Delivery Email
Statement Created
Statement Created
Categories
Chart of Accounts QBO QuickBooks QuickBooks Online QuickBooks Online QBO

How can I document money taken out of personal checking to pay for some initial expenses?

Once you have transferred money from your personal to business checking account, this is how you will need to record the deposit in new QuickBooks Online.

Click “Plus” icon menu
Select Bank Deposit from “Other” menu
Choose the correct bank account (if you have more bank accounts)
Select correct date of deposit
Received From = Jimmy Smith (example only) > Add New as “Vendor” if needed (slightly different name if already setup as employee)
Account = Loan Payable to Jimmy Smith (example only) > Add New > Category Type > Other Current Liabilities > Loan Payable > Change Name to Loan Payable to Jimmy Smith > Leave Balance “Blank” > Save
Description = Temporary loan to the company, to be repaid within 60 days (for example)
Payment Method = Direct Deposit/Check/Cash??
Ref No = Bank deposit reference number if available
Amount = exact deposit amount (say $5,000 for this example)
Save and Close

Loan repayment to Jimmy Smith

GO to Vendors
Select Expense (if bank transfer) > select Check if issued check
Select Jimmy Smith (Vendor)
Account = Loan Payable to Jimmy Smith
Description = Repayment of loan with borrowed date
Amount = $5,000.00 (if full re-payment)

Those two entries should document borrowed money for business as well as repayment. And, the account should reflect zero balance when done.

Categories
Customer Center Customers Customers Center Invoice

How can I see if a Customer has opened/viewed an Invoice in new QuickBooks Online?

Select the blue navigation bar on the left

  • Select Customers Center
  • Locate Customer and click “Open Invoices” under Pending Invoices column
  • Under Status column you will notice either “Open (Viewed)” or Open (Sent)”
  • That’s your confirmation if the invoice has been viewed or not.
  • See attached screenshot photo below for reference.
Invoice Open Viewed Sent
Invoice Open Viewed Sent

This is one of the coolest features available in new QuickBooks Online.
Another cool feature is when customer opened the Invoice, on the side bar, it will put a stamp indicating what time customer viewed the invoice. Customer can also reply to your email from the same “Send a message” box.

Customer Send a Message Box
Customer Send a Message Box

Google+

Categories
Profit and Loss Reports

I need to track revenues and expenses across multiple lines of business. Does QuickBooks Online Plus support profit and cost centers?

You can establish Profit and Cost Centers by enabling Class tracking feature in new QuickBooks Online Plus.

To enable Class tracking feature:

  • From the Home page screen
  • Select the Company Gear (top upper corner)
  • Select Company Settings under Settings header
  • Select Company
  • Select/Double Click to enable “Track Classes On” under Categories
Class Tracking
Class Tracking
Categories
Check

How do I void an outstanding check from a previous period and re-issue a replacement in the current period without having to re-state financial statements?

I understand you are not asking just how to void and re-issue check. Your accounting question which involves few steps in QuickBooks online plus or desktop version for that matter.

For this example, let us say you wrote a check, void original check and reissue on 12/16/2013.

Vendor: AT&T
Date: 9/15/2013
Amount: $100.00
GL Account: Telephone Expense
It takes four steps process in order not restate your financials.

Step # 1

Write a Journal Entry (click “plus” icon > select journal entry from other menu)
Write a journal entry dated 9/15/2013
Telephone Expense (debit) — $100.00 (Name = AT&T)
Bank account (credit) — $100.00 (Name = AT&T)

Step # 2

Reverse journal entry on 12/16/2013 (that’s the day you are reissuing you new check)
Telephone Expense (credit) — $100.00 (Name = AT&T)
Bank account (debit) — $100.00 (Name = AT&T)

Step # 3

VOID (not delete) original check issued on 9/15/2013
Navigate the Check > click “More” button (located at the bottom) > enter replacement check number under description > select “VOID” > Save and close

Step # 4

Issue new check on 12/16/2013.
Make sure you use same GL account. In this example, its telephone expense account.
That should do it. Your telephone expense for September will not change. You will not see additional expense in December month.

NOTE:

When you do the bank reconciliation next time, in the Reconcile window, locate the entries that you created in steps 1 and 2 (one will appear on the Checks and Payments side, the other on the Deposits and Other Credits side). Click next to each entry to mark it with a check-mark.

Categories
bank reconciliation Bank Register Reports

How to view all uncleared / uncashed checks in new QuickBooks Online?

To check the status on a check you can run a Check detail report

  • Select the blue navigation bar on the left
  • Select Reports
  • Go to Report (magnifying glass) and type Check
  • Select “Check Detail”from the dropdown selector list
  • This report will provide all issued checks.
  • Once report is open click Customize button (top left corner)
  • Customize by:
    1. General > Transaction date > All Dates

      Lists > Transaction Type > Check

      Status > Cleared > uncleared

  • Run report

Customize Check Detail All Dates
Customize Check Detail All Dates
Customize Check Detail Check Uncleared
Customize Check Detail Check Uncleared
Uncleared Check Detail Report
Uncleared Check Detail Report
Categories
Bank Register

Where is the bank register in new QuickBooks Online?


Where is the bank register in new QuickBooks Online?

From the Home page screen

  • Go to the blue navigation bar on the left
  • Select Transactions
  • Select Registers
  • Locate the bank account on Registers list
  • Double click the bank account
  • “Find in Register” button (top upper right)
  • “Customize” button column (top left)
  • “Go to Ref # ” (top right)
  • Double click on transaction – Save Edit Cancel Delete bar will open
  • Click on “Edit” will take to original entry
  • “Reconcile” link (bottom right)

Bank Register
Bank Register
Categories
Check Print Checks

How do I toggle between Voucher Checks and Standard (3 part) Checks in new QuickBooks Online?

From the Home page screen

  • Go to Transactions (left blue navigation bar)
  • Select Print checks
  • Click on Alignment and Setup to change the check type
  • You can do this as often as you need to

Print Checks Choose Voucher or Standard Checks
Print Checks Choose Voucher or Standard Checks

Categories
Reports

How can I run a report that gives me the detailed automobile expenses for this year in new QuickBooks Online?

Run Transaction Detail by Account and customize the report to show just Automobile Expense account.
Select the blue navigation bar on the left

  • Select Reports
  • Go to Report (magnifying glass) and type Transaction
  • Select Transaction Detail by Account from the dropdown selector list

This report will show all transaction details by all accounts
We will to need to customize this report just to show Automobile Expense account only.

  • Change Transaction date as necessary (for example change to This Year to run report this year only)
  • Click Customize button (located top left corner)
  • Select “Lists”
  • Go to Distribution Account under Lists
  • Scroll down the list and select “Automobile Expense”
  • Select Run Report button
  • Now you’ve Transaction Detail by Account report for Automobile Expense account only.
  • If you need to run similar report for other accounts, follow the same steps, just select appropriate account from Distribution Account List.

You can also customize this report (click Save Customizations button) if you need to see just Automobile Expense next time.

Transaction Detail by Account Customize
Transaction Detail by Account Customize

Transaction Detail by Account
Transaction Detail by Account
Run Transaction Detail by Account and customize the report to show just Automobile Expense account.

Other way to generate that report is to use your chart of accounts to create a “QuickReport.”

To do this:

  • Click on the gear in the top right and choose “Chart of Accounts” in the dropdown
  • On the chart of accounts, scroll down to the expense account you categorized your interest to
  • Click on that account once and then click the “Report” button in the upper right
  • Set your date range at the top of the report and click the “Run Report” button and you’re good to go!
Categories
Recurring Transactions

Where can I find recurring transactions in new QuickBooks Online?

Lists Recurring Transactions
Lists Recurring Transactions

From the Home page screen

  • Select Company Gear (top upper corner)
  • Select Recurring Transactions under Tools header

They have three template types of recurring transactions:

  • Scheduled
  • Reminder
  • Unscheduled

You can also create new recurring transactions from here by clicking NEW button.

They have the following interval to set up:

  • Daily
  • Weekly
  • Monthly
  • Yearly

You can also Edit, Use or Delete the recurring list.

Reminder List
This list contains reminders of transactions that are due to be created soon.
Each reminder is an occurrence from a recurring template.
To review a reminder, click Edit & Create. Then you can create a transaction from the reminder as is, or edit it first.
To avoid creating a transaction from a reminder, select the reminder and click Skip Selected. This deletes the single occurrence, but doesn’t affect the recurring template behind it.
To create many transactions at once without reviewing them first, select their reminders and click Create Selected.
A reminder may have a red ! at the left. This means it needs to be edited.