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.

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