Categories
Customers Vendors

Can I change the default A/R or A/P account in QuickBooks Online

Can I change the default A/R or A/P account in QuickBooks Online
QuickBooks Help
QuickBooks Online (QBO) is not designed to work with multiple Accounts Receivable (AR) and Accounts Payable (AP) accounts. The initial AR and AP accounts, or those selected during conversion, will be the default accounts. We encourage our customers to merge their accounts payable and receivable accounts. For more information on merging accounts, please see Merging accounts, vendors, or customers. If division of open payables and receivables are needed use one of the following options…

 

FREE Trial
USA
CANADA

XERO - Alternative to QuickBooks

SAGE 50 Accounting

Limited Time Offer—Save Up To 37% On Sage 50 Accounting Software!

 






Categories
1099 Closings QBO QuickBooks Year End

Preparing for year-end: Hints and Tips for QuickBooks Online (QBO) users

Year-end is quickly approaching. Be prepared for the year-end. Here is a 10-point checklist you should go through to keep your QuickBooks Online accounts in order and plan for the year-end processing.

 

Helpful Checklist:

  1. Bank Reconciliations
    Make sure all bank reconciliations are up to date. This includes credit card accounts as well. Review any unmatched items (both deposits and payments) that you would not expect to be outstanding. This may be the result of a duplicate entry.
    It is important these banks reconciliations are printed (or saved) at year-end.
  2.  

    Click on the screenshots below to enlarge them
    bankrec

     

  3. Undeposited Funds
    Make sure all the customer payment items in Undeposited Funds account have not yet been deposited to the bank account. If all the deposits are already posted to the bank account, this account should show zero balance. Any balance in Undeposited Funds account (even after bank accounts are already reconciled) may be the result of a duplicate entry. Review income and account receivable accounts and resolve it.
  4. uf

     

  5. A/R and A/P Balances on Cash Basis
    Run the Balance Sheet on the cash basis accounting method. If the transactions were properly recorded, these two accounts should not show a balance in the Balance Sheet.
  6. arap_cash_basis

     

  7. Employee Advances
    Make sure Employee Advances account is reconciled. This account should include the advances that are yet to be repaid or have not been deducted from the payroll.
  8. emp_advance

     

  9. Payment to Independent Contractors (1099s)
    Make sure you have IRS Form W-9 on file and they are up to date.
    You can google 1099 and W-9 for all the handy information you need.
  10. track1099

     

    BUY QuickBooks Online - Anytime, Anywhere. Easily Track Sales, Bills and Expenses.
    Beach Vacation Rentals under $100 a night
    Save on Smartphones from Verizon Wireless!
    Over 4000+ STD Test Centers Nationwide. Order Testing Today!

     

  11. Other Balance Sheet Accounts
    Review all other balance sheet accounts. Make sure all assets and liabilities are shown properly. It is also time to make adjustment entries if necessary.

     

  12. bsaccts

     

  13. Depreciation on Fixed Assets
    If you have posted your depreciation on fixed assets entry, make sure these are up to date. If not, consult your Accountant.
  14. depreciation

     

  15. Uncategorized Income & Expense / Ask your Accountant
    If you have any uncategorized income and expense in P&L that have been used to post entries that you aren’t sure what to do with, now is the time to have a look. If needed, ask your Accountant and resolve it. Also, review all income and expense accounts and make sure it makes sense.
  16. uncategorized

     

  17. Retained Earnings
    Keep a separate spreadsheet Account Analysis of Retained Earnings account. This account should include income or loss from prior years. It may also include reclassifying transactions within equity type accounts. Consult your Accountant if it involves any entry posted from outside of equity accounts.
  18. re

     

  19. Close the books
    Close the books once you have submitted final numbers to your Accountant for review and tax preparation. Consult your Accountant in case there is a need to make changes.
  20. closing

     

Categories
Company Gear Company Settings Customers Invoice Sales

How to handle a partial payment when creating an invoice in QBO?

Case: A customer bought $105.00 worth of product and paid $80.00 in cash. You need to send an invoice to the customer for the balance. How would you handle this in QBO?

First, create a new invoice using product/service item code for $105.00. Use deposit field to post $80.00 as the prepayment on that invoice. Deposit field is located right below the total. Now, the invoice will show $25 balance due.

If you do not see “DEPOSIT” field on your invoice, go to “Company Gear” settings to enable deposit field: Gear icon (upper right corner) > Settings > Company Settings > Sales > Deposit > ON > save. See screenshot below for reference.

Click on the screenshots below to enlarge them
enable deposit setting

Once you enter deposit amount, your invoice screen will expand to show the following three fields added to the invoice form. Fill out the information appropriately:

a) Payment method
b) Reference no.
c) Deposit to

You will need to select “Deposit to” field depending on your situation. If you are depositing this deposit (prepayment) to the bank along with other payments as a batch deposit, then you should select Undeposited Funds Account. On the other hand, if you are depositing just $80.00 as a single deposit to the bank, you should select the appropriate bank account.

deposit field on invoice

The snapshot below shows what accounts are affected by this transaction:
deposit journal report
1. Accounts Receivable: $25
2. Sales Income: $105
3. Undeposited Funds or Bank Account: $80

 

#QuickBooks Online

 

Categories
Company Gear Company Settings Multi Currency

QuickBooks Multicurrency in QuickBooks Online US

With QuickBooks Online (QBO) multi-currency, you can track transactions in more than one currency. Multicurrency affects many accounts and balances in company file and the preference can’t be turned off once it’s been turned on.

Important: Since you cannot really back up company file (with all the features and the settings) in QBO at this time, make sure this is what you want before turning on this multi-currency feature.

The multi-currency menu items are in the Company Settings menu under Currency in the QuickBooks Online.

From the home page screen > company gear (upper right corner) > settings > company settings > currency > ON > Save

Click on the screenshots below to enlarge them
1enable currency feature

Multicurrency once enabled from the QuickBooks Online, one cannot UNDO it. See screenshot below, there is no edit pencil icon for currency, once the currency feature is ON.
2currency feature enabled

Once the multi-currency is enabled, it will do two visible things:

  • It will create “Currencies” under lists.
  • It will create “Exchange Gain or Loss” account under “Other Expense” type.

lists currencies

exchange gain or loss account

Currency exchange rate

Once set, the company’s home currency cannot be changed:
For US QuickBooks Online editions, the home currency is set to USD, by default.
Exchange rates are always recorded as the number of home currency units it takes, to equal one foreign currency unit.

To add new currency > from the home page screen > company gear (upper right corner) > lists > currencies > add new

home currency table

How to start using the multi-currency feature?

  • After you turn on the feature, you will be able to assign a currency to customers, vendors, and other accounts.
  • You can assign one currency for each customer or vendor so you will create new customers or vendors to use in your foreign transactions.
  • You can assign one currency for each account so you will create new accounts to use for your foreign transactions.
  • If you prefer to use your own exchange rates, you can manually enter those as well.

The following image shows how these currencies attributes in an Invoice transaction relate to the representation of the invoice.
invoice in gbp

Customer Center > from the home page screen > left navigation bar > customers

customer center

Customer Page > from the home page screen > left navigation bar > customers > customer

customer page

It also automatically creates separate Accounts Receivable accounts (not sub-accounts) by currencies in addition to main home currency A/R.
ar accounts by currencies

A/R Aging Summary Report in home currency
ar aging in home currency

Balance Sheet Report
Since A/R (and A/P) not sub-items type, it cannot be collapsed even if wanted.
balance sheet

(All Vendor side transactions and reports also work the same way as Customer transactions).

Mult-currency features not available

Weekly TimeSheet and Single Time Activity entered (either by employee or vendor contractor) do not work with multi-currency at this time. You will get the following error message:

“The following errors have occurred: You must choose a customer that uses local currency when time is billable.”

multicurrency single time not working

multicurrency timesheet not working

 

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!

RELATED ARICLES:

Where does QBO get its currency exchange rates from

Which versions of QBO support the multi-currency feature

Categories
Company Gear Company Settings Customers Reports

#QuickBooks Online #QBO – How to handle zero balances in accounts receivable aging

You have two ways to handle this issue in QBO:

  • Manual Setting
  • Automatic Setting (auto-mode)

You will need to select the one which is right for your business situation. When you create a new company file in QBO, normally this auto-mode is already ON as a default setting.

1zero ar aging

Manual method is commonly used when you have several customers open invoices and need to apply issued credit and received payment against a specific invoice. The credit memo may directly be related to certain specific project or a product return.
For example, you issued several product invoices to a customer. They returned one product and you had to issue a credit memo. They paid that invoice and also deducted for product return. For your business, you want to make sure, transactions (payment and credit) for that invoice is handled correctly. You would want to manually select that invoice; enter receive payment; apply credit and clear that invoice in A/R Aging.

To clear zero balance in A/R Aging:
From the home page screen > left navigation bar > customers > customer page > go to customer invoice > select “Receive Payment” under “Action” column
It will take you to “Receive Payment” screen. “Amount Received” should show zero because clearing “outstanding” and “credit” are for the same amount. Choose Save and Close. It should clear (disappear) zero balance in A/R Aging. Now, on customer page, status should indicate paid (instead of partial) and closed (instead of unapplied).

Click on the screenshots below to enlarge them
2customer page

3clear ar

4clear customer page status

Automatic method (default setting in QBO)
You can also choose “automatically apply credit” setting in QBO. By turning this setting ON, it will automatically apply credits to the next invoice you create for the same customer. General service-based companies (or non-project oriented companies) prefer turn on this setting. They do not deal with product returns. Invoices they issue are not sensitive to any specific project.

To turn on this automatic setting in QBO:
From the home page screen > company gear (upper right corner) > settings > company settings > advanced > automation > Automatically apply credits ON > save

5automatically apply credit setting

Once this automation setting is on, it is automatically take care of payment and credit. You will not see zero balances in Accounts Receivable Aging.


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!