Categories
Check Print Checks Vendor

#QuickBooks #QBO What is the maximum digits you can use for a check number

A check number can be of up to 21 digits.

To sign up QuickBooks for a free trial from US Canada UK and Australia, bookmark this URL link > www.newqbo.com/sign/

check number digits

 

Weekly Price Check US CA UK AU (Plus Plan)

USACanadaUKAustralia
us120x90ca120x90uk120x90au120x90
USD 23.97 per monthCAD 14.50 per monthGBP 15.00 per monthAUD 21.00 per month
USD 23.97 per monthUSD 12.01 per month
(Conversion)
USD 23.30 per month
(Conversion)
USD 16.60 per month
(Conversion)
LOWEST PRICE!

 

#QuickBooks Online

 

Categories
Check Pay Bills Print Checks Vendor Vendors

#QuickBooks – How do I enter and print reference information on voucher checks?

In QuickBooks Online, there is no feature setup to print reference number (or vendor bill number) on voucher checks. Reference number comes directly from entered bill number field.

 

Here is a sample of Voucher Check printout:
Click on the screenshot below to enlarge it
voucher check

  • Reference column = entered vendor invoice number on “bill no.” field
  • Original amount = vendor invoice amount
  • Printer setup selection = voucher (not standard)

Weekly Price Check US CA UK AU (Plus Plan)

USACanadaUKAustralia
us120x90ca120x90uk120x90au120x90
USD 23.97 per monthCAD 14.50 per monthGBP 15.00 per monthAUD 21.00 per month
USD 23.97 per monthUSD 12.01 per month
(Conversion)
USD 23.30 per month
(Conversion)
USD 16.60 per month
(Conversion)
LOWEST PRICE!

 

#QuickBooks Online

 

Categories
Customers Pay Bills Receive Payment Vendor Vendors

I have a vendor that I purchase from and who also purchases from me. How do I handle this barter transactions in QB online?

A barter transaction is one in which you buy products and services to a person (vendor) or company from whom you also sell other products and services (customer).

Set up the bartering process in QBO:

  1. Open your vendor center and add the vendor to your vendor information screen with a “(V)” after the name.
    From the home page screen > left blue navigation bar > Vendors > New vendor (upper right corner) > Fill out vendor information > Example: Barter Enterprises (V)
  2. Open your customer center and add the customer to your customer information screen with a “(C)” after the name.
    From the home page screen > left blue navigation bar > Customers > New customer (upper right corner) > Fill out customer information > Example: Barter Enterprises (C)
  3. Set up a new bank account for your barter transactions.
    From the home page screen > left blue navigation bar > Transactions > Chart of Accounts > New > Category Type = Bank > Detail Type = Cash on hand (or select one) > Name = Barter Clearing > Description = Bank Clearing – Same Vendor and Customer

Check out our helpful YouTube tutorial video. Be sure to subscribe our channel. Follow us on Twitter (@newqbo). We highly encourage you to watch the entire video.. You do not want to miss a step!

 
vendor

customer

barter bank

Enter Bills and Invoices:
Enter Bills and Invoices as normally would. No difference. Make sure to select Vendor (V) on bills and the Customer (C) on invoices.
For entering Bill > From the home page screen > create + sign > vendors > bill
For entering Invoice > From the home page screen > create + sign > customers > invoice

create vendor bill

create customer invoice

 

Barter Settlement

Make payment due (money out) to the Vendor (V)
Case # 1:
Vendor Bill = $600.00
Customer Invoice = $500
Balance due to Vendor (V) = $100

Pay Bills and Receive payment

  1. To Pay Bills (partial $500) > From the home page screen > create + sign > vendors > pay bills
    Payment Account = Barter Clearing (IMPORTANT)
    Select “Pay” Vendor (V) checkbox
    Amount to pay = Same amount as Customer Invoice (example: $500)
    Starting Check No. = Non Cash Payment
  2. To Receive Payment > From the home page screen > create + sign > customers > receive payment
    Select Customer (C)
    Payment Method = Non Cash (add new if needed)
    Reference = Barter
    Deposit to = Barter Clearing (IMPORTANT)
    Select Outstanding Invoice transaction
    Amount = $500
  3. To Pay Bills (remaining $100) > From the home page screen > create + sign > vendors > pay bills
    Payment Account = Bank Account (IMPORTANT)
    Select “Pay” Vendor (V) checkbox
    Amount to pay = $100
    Starting Check No. = Non Cash Payment

vendor payment offset against customer invoice

customer payment applied against vendor bill

balance due payment to vendor

vendor page

customer

Review Bank Register for Barter Clearing account (from the home page screen > left blue navigation bar > transactions > chart of accounts > view register under action column
This account should have zero balance.

bank register

 

Receive payment due (money in) from the Customer (C)
Case # 2:
Customer Invoice = $2,000
Vendor Bill = $800.00
Balance due from Customer (C) = $1,200

Receive payment and Pay Bills

  1. To Receive Payment > From the home page screen > create + sign > customers > receive payment
    Select Customer (C)
    Payment Method = Non Cash (add new if needed)
    Reference = Barter
    Deposit to = Barter Clearing (IMPORTANT)
    Select Outstanding Invoice transaction
    Amount = $800 (partial)
  2. To Pay Bills > From the home page screen > create + sign > vendors > pay bills
    Payment Account = Barter Clearing (IMPORTANT)
    Select “Pay” Vendor (V) checkbox
    Amount to pay = $800 (same as vendor bill)
    Starting Check No. = Non Cash Payment
  3. To Receive Payment ($1,200 by check) > From the home page screen > create + sign > customers > receive payment
    Select Customer (C)
    Payment Method = Check
    Reference = Customer (C) check number
    Deposit to = Bank Account (IMPORTANT)
    Amount = $1,200

2 create customer invoice

2 enter bill

2 received payment offset by vendor bill

2 vendor bill payment

2 recevied payment by check

2 customer page

2 vendor page

Review Bank Register for Barter Clearing account (from the home page screen > left blue navigation bar > transactions > chart of accounts > view register under action column
This account should have zero balance.

2 bank register

 
Note: It can also make this barter process to work even if the customer and vendor are different, but need to settle out A/R and A/P balances.

 

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





Thank you!





Categories
1099 Vendor Vendors

How I can generate a 1099 summary report for non-employee compensation in QuickBooks Online Plus?

There is no built-in 1099 related summary report for non-employee compensation at this time

Here is how you can get that information.

Go to prepare 1099-MISC forms screen (blue navigation bar > vendors > prepare 1099s button (right corner) > “Follow the steps to prepare 1099-MISC forms” screen > Choose “Print using purchased forms” link (at the bottom) > side arrow will move down and expand with more information > select “Print Information Sheet” blue button (at the bottom).

It will show printable “1099 Information Tax Year 2014” report.

print using purchased forms
print information sheet
1099 information report


Updated 12/10/2015:

It used to be able to preview the 1099 Summary Report without having gone through all the prepare 1099 steps. There is no way to preview accounts and vendors meeting the threshold without going through the prepare 1099s steps now. It is not clear why the “1099 Transaction Detail by Vendor” is not even a built-in report at this time.

To run this report (go through all the steps), click on the Box 7 payment amount by any vendor to get a vendor report to support that value. See attached screenshots below.

prepare 1099s
1099 transaction

If you want to run this report for another vendor, you will need to do it all over again. Would not it be nice if they have the simple build-in “1099 Transaction Detail by Vendor” for ALL the vendors in one customize format?

Send them your feedback before it’s too late for this year.
Gear (upper right corner) > your company > FEEDBACK.

 

Related article:
What to exclude transactions on 1099-MISC forms when you pay an independent contractor?

Categories
Vendor Vendors

Where & how do I enter new W-9 information for sub-contractors in new QuickBooks Online?

Partial information from W-9 goes to Vendor Information screen. You need PLUS level subscription.

Most important info is to enter tax ID and “track payments for 1099” checkbox.

There is no way to actually attach actual W-9 form at this time.

If you feel this feature should be added to future revision, please make your voice heard by sending your feedback.

vendor info tax id
vendor info tax id
vendor prepare 1099s
vendor prepare 1099s
vendor prepare 1099s follow steps
vendor prepare 1099s follow steps
Categories
Vendor Vendor Credit Vendors

I returned items that were ordered for customer job and charged to my bank debit card. They will be refunded back to my bank debit card. How do I enter this credit into QBO back to customer job?

It is kind of hard of believe they do not have designated “Debit Card Credit Form” (or Expense Credit Form), just like one they have for Credit Card Credit Form.

I am not excited to give this way-around approach, but it will work especially recording credit for customer job related return.

#1 create new credit card type account. Call it “debit card clearing account” (or something similar). This has be to under CREDIT CARD Type.

#2 use credit card credit form (create + sign > vendors > credit card credit form). select this newly created “debit card clearing account” just like you select other credit card name when you return products paid by credit card. This will record credit return for the customer job. It will leave with negative balance.

#3 This one is extra step you need to do. GO to “Transfer” form (create + sign > other > transfer).

Tranfer Funds from = Debit Card Clearing Account from the drop-down list

Transfer Funds to = Selection of bank account used for debit card from the drop-down list

With step #3, debit card clearing account will have zero balance. Bank account should correctly reflect deposit amount.

Done. Everyting accounting wise should be work fine.

If you like to see “Debit Card Credit” form (or Expense Form paid by Debit Card) added in future revision, add your voice here. Remember, they make improvements based on your feedback.

From the home page screen > company gear (upper right corner) > your company > feedback

Note: Just for recording debit card credit for return (and if customer job is not relevant), you can go to bank register and enter as bank deposit. Or use Bank Deposit Form (create + sign > Other > Bank Deposit

debit card clearing account

debit card entry using ccc form

debit card transfer

debit card register

Categories
Vendor Vendors

Where & how do I enter new W-9 information for sub-contractors in new QuickBooks Online?

Partial information from W-9 goes to Vendor Information screen.

Most important info is to enter tax ID and “track payments for 1099” checkbox.

There is no way to actually attach actual W-9 form at this time.

If you feel this feature should be added to future revision, please make your voice heard by sending your feedback.

w-9 information
w-9 information

helpful videos

Categories
Bill Check Expense Settings Vendor Vendors

What happened to the “Items” tab when I enter bills?

show items table on expense and purchase forms on 2
show items table on expense and purchase forms on 2

If you see “Bill” form with account only and there is no  “Item Details tab” separately,  it usually means “Show Items table on expense” setting is turned off.

In order enable Show Items table on expense and purchase forms:

From the home page screen

  • Select the Company Gear (upper right corner)
  • Select Settings
  • Select Company Settings
  • Select Expenses
  • Select Bills and Expenses
  • Select Show Items table on expense and purchase forms
  • Check box to enable setting ON
  • Save
show items table on expense and purchase forms on 2
show items table on expense and purchase forms on 2
Categories
Vendor Vendor Credit Vendors

How should I really enter refund by a Vendor in new QuickBooks Online?

I followed the refund by a vendor. I entered as a deposit. But then it does not show in the vendor’s transaction listing. How should I really enter this type of transaction?

At this point, they do not have have any designated way to record this transaction. It is just work-around approach to show in the Vendor Center’s transaction listing.

#1 Create Vendor Credit
From the home page screen

  • Select “Vendor Credit” tab under Vendors heading
  • Choose a vendor
  • Make sure account selection (that be entered as account for credit entry) is the same as original account. This is to show applying credit to the same account. For example, you bought printer and expensed it to Computer Expense account . Returned it and received refund for the returned item. Use the same account to credit the refund from the vendor.

#2 Show Bank Deposit for Refund
From the home page screen

  • Select “Bank Deposit” tab under Others heading
  • Choose Bank account for deposit
  • Received From = Name of Vendor from the drop down list who gave you refund
  • Account = Accounts Payable from the dropdown chart of account
  • Amount = refund amount deposited to the bank
  • Enter other related information
  • Save

#3 Unncessary extra step but got to do it

GO back to Vendors Center (blue navigation bar > Vendors > Locate specific Vendor), you will notice “1 Open bill” message under Pending Bills for that Vendor. This could be flawed in QBO design at this time.

  • Select “Make payment” button under “Action” column
  • New “Bill Payment” screen will open
  • You will notice in and out with zero amount transaction
  • Change Ref number to “blank”
  • Save and Close

“1 Open Bill’ message is gone now.
Again, this is unncessary step in new QuickBooks Online.

How should I really enter refund by a Vendor in new QuickBooks Online QBO

Categories
Vendor Vendor Credit Vendors

How do I apply a specific vendor credit when paying vendor bills? We have several vendor credits against this vendor.

Do not use “Paying Bills” feature when you want apply a specific vendor credit.

It seems there is even a design flaws on “Paying Bills” feature when it comes applying a specific vendor credit when you’ve multiple vendor credits in Vendor’s account. Credit column provides no ability to select specific reference to available vendor credit.

Alternative solution is to create payment Check from the Vendor’s Center.
From the home page screen

  • Go to blue navigation bar on the left
  • Select Vendors tab
  • Select Vendor that needs to be paid
  • Select checkbox of “Bills” need to be paid and also select checkbox of Vendor Credit to apply against this payment
  • GO to Create New button (far right) and select “Check” from the drop-down
  • It will take to new Check#To Print screen
  • Go to far right and select “Add All” under “Add to Check”
  • It will show paid check amount with outstanding bills as well as specific referenced credit
  • Choose “Print Check” at the bottom
  • Choose Preview and Print (bottom right corner)
  • Select Print button

Vendors – how to apply a specific vendor credit against vendor bill payment in new QuickBooks Online