Categories
Chart of Accounts Credit Card

Why is my credit card beginning balance negative

You will first need to check the account TYPE in the Chart of Accounts.
If you’ve manually entered the credit card balance as a positive number when, creating a new account in the Chart of Accounts, on reconciling screen, your beginning balance should also be positive, not negative.

You will need to check the TYPE on your chart of accounts. For credit card account, the CATEGORY TYPE should also be “Credit Card” not Bank or something else. If it’s not setup as credit card type, you will need to edit from pull-down arrow next to view register in the chart of accounts.

coa-credit-card-type
coa-credit-card-category-type






Categories
Chart of Accounts Inventory Journal Entry Sales Receipt

How to track donated inventory stock items by your business in QuickBooks

These are the specific steps you can follow in QuickBooks Online (available in plus plan only) if you are donating or giving away tracked quantity on hand inventory items.

Create ZERO Value Sales Receipt for Inventory Items:
1. From the Home Page screen > click Create (+) Sign (top middle bar) > Customers > Sales Receipt and create a Sales Receipt for the inventory item.
2. Choose a customer (name of donating company). Add new if needed.
3. Select Item Donation as your Payment Method. Add new if needed. Optional.
4. For “Deposit to” field, select Add new and create bank category type account. Name it clearing account. (This will create just a zero dollar transaction. You would not have any actual banking transactions in this bank register).

Screenshot 2016-07-17 16.03.31

 

5. In the Product/Service column, click the drop-down arrow to select the product/service you are donating.
6. Change the Rate of the selected product/service to zero so that the total of the sales receipt is zero.
7. Click Save.

Screenshot 2016-07-17 16.01.32

 

8. Click “More” at the bottom. Select Transaction Journal report. This will give you the original cost of the inventory items you are donating. Print as PDF or select export to excel. Do the same for the Sales Receipt.

Screenshot 2016-07-17 16.01.58

Screenshot 2016-07-17 16.02.07

 

Next, to account for the original cost of the product/service(s) selected, create a Journal Entry to move the cost out of the Cost of Goods Sold account and into the appropriate expense account (for example, Charitable Donations Expense).

To record this:
1. Click Create (+) sign > Other > Journal Entry.
2. In the Account section, choose the expense account used to track charitable contributions (for example, Charitable Donations Expense).

Screenshot 2016-07-17 16.03.09

 

3. Enter the cost of the product/service in the Debit field.
4. On the next line, click the drop-down arrow and select the Cost of Goods Sold (COGS) account for the donation.
5. The cost of the product/service entered in the field above will populate the Credit field.
6. Click Save.
7. Optional. Attachments (bottom left) for the record. Attach Transaction Journal (that gives you how you got the cost of the donated items) and Sales Receipt.

Screenshot 2016-07-17 16.00.01

Screenshot 2016-07-17 15.59.39
 

Our YouTube Tutorial Video: How to track donated inventory stock items by your business in QuickBooks

 

Categories
Chart of Accounts Reconcile

How to reconcile the Undeposited Funds account the same way like bank accounts

Currently, there is no option to reconcile undeposited funds account. The undeposited funds account is not on the listing of accounts that can be reconciled like for bank, credit card and other assets and liabilities accounts.

Interestingly, it’s sort of automatically reconciled when existing payments from the undeposited funds transferred to the bank account. What’s left in the account is treated as unreconciled status. To get the unreconciled status data, you can get the information directly from the undeposited funds register, you will need to follow these steps:

From the home page screen > left navigation bar > transactions > chart of accounts > select undeposited funds account and click view register under action column > once you’re on the asset register, click little funnel icon arrow down > select ” Not Reconciled” under reconcile status > select all dates > apply
All the items remaining on top without “R” sign (payment and sales receipt) represents “Not Reconciled” status. The total amount should match with the shown “Ending Balance” on top of the register. You can print or download to excel this report.

reconcile undeposited funds
reconcile undeposited funds

The only problem with this report is, there is no way to get the running balance that they took it out on their last update. When sort, you will see “n/a” only with no balance or grand total. If you think you need running balance or grand total instead of “n/a” only, send them your feedback request here:

http://feedback.qbo.intuit.com/forums/168199-quickbooks-online-feature-requests/suggestions/10331052-running-balance-in-check-register


 

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





Thank you!





Sign up QuickBooks USA

Categories
1099 Bank Deposit Chart of Accounts Check Expense Expenses Vendor Vendors

Owner paid a subcontractor with his own money. How to make sure Vendor shows up on 1099 and still able to write the reimburse check to the Company Owner

First, you will need to create a new dummy bank account. You will also need a due to the owner as a liability type account to use it for later reimbursement.

Step#1 Use bank deposit form (create + sign > other > bank deposit) to record contributed amount by the owner to pay a contractor. Account to show as due to the owner liability type account. See screenshot below.

owner deposit
owner deposit

Step#2 Use Expense form (create + sign > vendor > expense) to create contractor expense posted to appropriate expense account. See screenshot below.

contractor expense
contractor expense

Step#3 Use Check form (create + sign > vendor > check) to write the reimburse check to the Company Owner. See screenshot below.

check to owner
check to owner

In case there is no need to reimburse the owner (step#1), you will use a capital contributed account which would be an Owner’s Equity type account.

Review of 1099 vendors and payments list. See screenshot below.

review 1099 vendors payments
review 1099 vendors payments

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





Thank you!






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!

Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada








Categories
Chart of Accounts QBO QuickBooks

How to account for the gain or loss on a fixed asset sale

Categories
Chart of Accounts Products & Services

How to change the account associated with product and service item

Categories
Chart of Accounts

How do I set up Owners or Partners Equity in Chart of Accounts

Categories
Chart of Accounts

Importing a chart of accounts (COA) from Excel file

Categories
Bank Register Chart of Accounts Reconcile

Entered opening balance is wrong. How to fix it.

Categories
Chart of Accounts Transactions

#QuickBooks – How do I start with a blank chart of accounts in QBO?

If you’re a new customer and are within the first 60 days of having set up your account, you can delete all of the existing data and start over from scratch. If your account has been setup for more than 60 days you will need to cancel your current company and start a new company in order to start from scratch.

To complete the process, follow the instructions below:

Log in to your QuickBooks Online company.
Change the URL to include /purgecompany instead of /homepage

EXAMPLE:

URL shows: https://qbo.intuit.com/c27/app/homepage
Change to: https://qbo.intuit.com/c27/app/purgecompany

Steps:

  1. Change url to /purgecompany
  2. Enter YES
  3. Select Create an empty chart of accounts (select only with the advice of an accountant)
  4. Click Wipe Data
  5. Done. It will automatically take you back to the home page.

This option is available in Plus Plan and Essentials Plan. It is not available in Simple Start.

Click on the screenshots below to enlarge them
1purgecompany
2purgecompany
3purgecompany

Depending upon company type selection, QBO will keep only few default accounts. Do not delete those accounts.

4cleancoa

Tutorial Video

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





Thank you!






Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada








 

#QBO Plus and Essentials