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.

Categories
Vendor Vendor Credit Vendors

Where to enter credit for returned items or purchases in new QuickBooks Online?

(1)  Try “Vendor Credit” form (from create “+” sign > Vendor Credit under Vendors header) If you are using “Enter Bill” form to enter vendor bill and returning to the same vendor, you could use Vendor Credit form. It will show negative Vendor balance.


(2)  For returning credit for Credit Card purchases > use Credit Card Credit form 


(3)  For returning credit for Debit Card purchases (or purchases paid by check) > use Make Deposits. In new QBO, they do not have Debit Card Credit or or Check Credit Expense Credit form at this time. There is a known problem using Make Deposits feature. It will not show up in the Vendors center. This is a huge known problem in new QuickBooks Online.

Return Credits
Return Credits

Categories
Custom Form Styles Customer Center Customers Customers Center

How do i change the quantity to hours on description section of the Invoice in new QuickBooks Online?


In new QBO, open the Invoice form

  • Click “Customize” button (located at bottom middle)
  • Add personality to your forms will open
  • Select Columns
  • Under Quantity and Rate column, change Quantity to Hours
  • Save
  • See screenshot photo for reference

change column from quantity to hours
change column from quantity to hours

Categories
bank reconciliation Bank Register Chart of Accounts

How do you set up the bank account in QBO? I want to manually type the entries into QBO.

From the Home page screen

  • Select the Company Gear (top upper corner)
  • Select “Chart of Accounts” under Settings header
  • Select “New” button
  • New Account screen will open
  • Category Type = Bank
  • Detail Type = Bank account type (like checking or savings)
  • Name = Name of the Bank 
  • Description = Same as name (with acct number optional)
  • Save

Note: Leave BALANCE blank. You will need to write an appropriate entry for the opening bank balance separately.

Open New Bank Account
Open New Bank Account

Categories
Chart of Accounts

How to not display deleted bank account (like bank account > deleted) with zero balance on the Balance Sheet (or Profit and Loss) report?

There is no way to permanently delete accounts in new QuickBooks Online. You can make account inactive. That’s all in new Quickbooks Online.

Best solution is to customize Balance Sheet report.

  • Run Balance Sheet
  • Click Customize
  • Click Row/Columns
  • Select Rows = Non-Zero
  • Select Columns = Non-Zero
  • Run Report
  • Save Customizations button and save it as a special report.
  • See screenshot photo for reference.
Customize Non Zero
Customize Non Zero

Categories
Banking Chart of Accounts

I would like to stop importing data from a bank account. How do you disconnect a bank account (or a credit card account) added into online banking?

In new QuickBooks Online, disconnecting an account isn’t exactly in an obvious spot. To disconnect an account from online banking, we’re going to want to start in the upper right by clicking the little company gear, and then choose Chart of Accounts under settings. We’re going to click the connected account (you can tell it’s connected because it has two little arrows pointing in opposite directions) and then click the “Edit” button. You will see at the bottom of the pop-up that appears that there’s a check box that says. “Disconnect this account on save.” Check that box and click save, and you’re done!


Categories
Bank Deposit

How to print my bank deposit slip if payment method type is credit card?  I am receiving an error message that my payment type cannot be credit card.

Bank Deposit Slip
Bank Deposit Slip

Deposit Slip Error Message
Deposit Slip Error Message

In order to print a deposit slip with a payment type credit card we need to check your payment list settings and make a small change.

From the Home page screen

  • Go to the company Gear and select “All List “then select “Payment Methods.”
  • Select the payment method that is part of your deposit slip and click edit.
  • Uncheck the credit card box and save.
  • Return to your Bank Deposit screen and attempt to print again. Once its printed return to the payment method list and re select the credit card option and save.

Uncheck Debit Card Payment Method
Uncheck Debit Card Payment Method

Uncheck American Express Card Payment Method
Uncheck American Express Card Payment Method

Categories
Chart of Accounts Customer Center Customers Customers Center Deposit

In Peachtree I enter receipts from cash I received into two different accounts. Depending whether is rental payment or security deposit. Now, how do I create cash accounts in QB?

In newQBO, you will need to create new accounts setup in Chart of Accounts:

  • Cash Account (Bank Type)
  • Rental Payment (Income Type)
  • Security Deposit (Other Current Liabilities Type)

(From Company Gear, top upper corner > select Chart of Accounts under Settings header)
Also, if you are creating Sales Receipt, you will need to Product/Service Item for these two:

  • Rental Payment (Income account linked to Rental Payment)
  • Secuirty Deposit (Income account linked to Security Deposit account)
  • (From Company Gear, top upper corner > select Products and Services under Lists header)

For creating Sales Receipt (From create “+: plus sign, top middle > select Sales Receipt under Customers)
In newQBO, you will have to constantly deal with Three Amigos.

  1. Create “+” sign = enter all transactions
  2. Gear = settings/preferences
  3. Left navigation bar = history, reports, banking, customers/vendors center
Categories
Bank Register Reports

How can I undo the previous bank reconciliations in new QuickBooks Online?

QuickBooks Online doesn’t have an Undo Last Reconciliation feature. To unreconcile a reconciliation you’ll need to unreconcile each transaction via the register.

Reconcile
Reconcile

To access and print a previous reconciliation report:

  • From the gear icon go to Reconcile.
  • Choose the account from the drop-down list.
  • Click on the desired reconciliation report.
  • Once the report is open, click Print.

To undo a reconciliation:

Reconcile Go To Register
Reconcile Go To Register
  • Select Transactions on the left menu then Registers.
  • Click on the account then click Go to Register
  • Find the transactions that need to be unreconciled, one at a time.
  • To highlight click on the transaction.
  • Click on the R on the top line of the transaction, which is between the Payment and Deposit or Charge and Payment amount. Clicking in this field will allow you to change the status of the transaction to the desired status from blank = unreconciled to C = Cleared.
  • Click on Save.
  • A message will appear: This transaction has already been reconciled. You should only remove the R if you’re correcting a mistake. Are you sure you want to remove the R? click Yes.
  • Continue this process for each transaction on the reconciliation report or statement you want to unreconcile.