Categories
Depreciation Journal Entry

How do I record fully-owned fixed asset equipment that has been sold for cash?

If it’s fully-owned that means you should not have liability balance in your QuickBooks. But what about the asset value and accumulated depreciation?

You will need to remove the asset and accumulated depreciation from the books and also figure out the Gain or Loss on Sale of an Asset. See the screenshot below on how to set up this account.

You can write a Journal Entry in QBO to record this transaction.
For Example:
Let’s say you sold the vehicle for $2,000
The original Cost is $10,000.
Accumulated Depreciation is $9,000.
Gain on Sale of an Asset is $1,000. (Gain is credit. Loss is debit)

Your Journal Entry will look like this…see the screenshot below for reference.

Also, make sure depreciation expense is up-to-date. That will change the accumulated depreciation amount if it’s current.

Gain on sale of fixed asset
Gain on sale of fixed asset
Gain on sale of asset
Gain on sale of asset – Journal Entry

 

Categories
Customers Invoice Journal Entry QuickBooks Online QBO

How to Reverse an Accounts Receivable Written-off as Bad Debts Expense Account

CASE SCENARIO:

  1. A customer never paid the Invoice for $1,000. Wrote-off as bad debt expense account.
  2. Later paid $1,000.

You will first need to check to the original entry to see how the debt was written off to the bad debts expense account. For example, wrote a journal to wrote off a debt of $1,000 by debiting the bad debts expense account and crediting account receivable account.

To make this simple, you will need to reverse what you did. This will typically be a two-step process in order to record the recovery of bad debt payment.

  1. Reverse the original entry (Journal Entry) by crediting the bad debts expense account and debiting accounts receivable account with $1,000.
  2. Record the customer’s receipt by debiting the bank account and crediting accounts receivable account. In this example, debit the bank account and credit accounts receivable account with $1,000.
How to Reverse an Accounts Receivable Written-off as Bad Debts Expense Account
Categories
Bank Deposit Bank Register Banking Journal Entry Refund Receipt Sales Receipt

How do you match a deposit to a receipt when the credit card refund is more than the actual deposit

Example:
We received a credit card payment from customer A ($334.00) and sent a credit card refund ($1,000.00) to customer B on the same day. This resulted in a net negative deposit ($666.00) from our credit card merchant provider. How to match a refund receipt and a regular receipt in order to properly match the deposit in our bank account from the bank feed.

sales receipt
sales receipt

refund receipt
refund receipt

QuickBooks Online won’t allow creating a negative bank deposit. If the total deposit is negative, you will need to create a Journal Entry to move the funds from Undeposited Funds to the bank account.

deposit negative
deposit negative

Here’s how to create that Journal Entry and move the funds from Undeposited Funds account to Bank account.

journal entry
journal entry

  • Click the Create (+) at the top of your Home screen.
  • Choose Journal Entry from the drop down (if you don’t see it, try clicking Show more).
  • Set the Date of the transaction (same as bank posted transaction date).
  • On the first distribution line of the Journal Entry:
  • In the Account column, choose Undeposited Funds.
  • In the Debit column, enter the amount of the deposit.
  • On the second distribution line of the Journal Entry:
  • In the Account column, choose the appropriate bank account.
  • Set the Credit column to the amount of the deposit.
  • Click Save and close. This will show a deduction from the bank account in the Bank Register in QBO.

Next, you will want to group the Journal Entry with the payments to create a $0 deposit and remove the payments from Undeposited Funds.

deposit zero with je
deposit zero with je

  • Click the Create (+) at the top of your Home screen.
  • Choose Bank Deposit from the drop-down.
  • Select the payments (negative and positive) and the Journal
  • The entry you just created (the total should be zero).
  • Click Save and close.

Next, go back to banking center (bank feed). You may see MATCH now for that transaction. If not, click that transaction row for refund receipt. Locate and match transaction from the list there. Save.

radio button switch from add to find match
radio button switch from add to find match

match transaction
match transaction

Video Tutorial

QuickBooks Online QBO – how to match negative credit card daily sales receipts | refund deposit

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
Check Journal Entry Reconcile

In setting up my new QuickBooks file, how do I enter the existing bank account balance with outstanding uncleared checks

It really depends upon how they were reported in previous year’s Financial Statement Report.

Let’s take examples and assume the ending bank balance per the bank statement is $11,000. There is also one check you wrote for $10,000 has not cleared the bank yet. In your books, the actual bank balance should be $1,000, right?

Example #1: You have already reported $10,000 as an expense in the previous year’s financial statement.

Since you have already reported, you do not want to expense it again in the current year. You would post $10,000 check as “Prior year” activity, with a prior date. This way, you can put the bank statement’s ending balance and have the uncleared check as outstanding, for the purpose of bank reconciliation.

example1_1

example1_2

example1_3

example1_4

Example #2: You have not reported $10,000 as an expense in the previous year’s financial statement.

This becomes your current year financial activity when the check has cashed the bank. If you are downloading banking transactions, you would expense it when the bank posted the transaction. In setting up QuickBooks file, the bank balance is $11,000, the same as the bank statement balance.

example2_1

example2_2

example2_3

example2_4


If you found our answers useful then please contribute a 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
Credit Memo Customer Center Customers Journal Entry Receive Payment

How can I transfer unapplied credit from one customer to another in QuickBooks Online

A case may occur when a customer wants to apply credit balance to an affiliated company’s open invoice.

EXAMPLE:

Customer (Mark) has a $500 credit balance. Customer (Martha) has a $500 Open Invoice. They like to clear the accounts by applying $500 credit from Mark’s account to $500 Open Invoice of Martha’s account.

One easy way to handle transfer credit from one customer to another customer is to write a Journal Entry in QBO.

Click on the screenshots below to enlarge them

Customers Page
Customers Page

Customer Mark's Account with $500 Unapplied Credit
Customer Mark’s Account with $500 Unapplied Credit

Customer Martha's Account with $500 Open Invoice
Customer Martha’s Account with $500 Open Invoice

 

To create a Journal Entry

From the home page screen, click Create+ sign

  • Click Journal Entry tab under Other heading.
  • Enter the date.
  • On the first line, from the Account drop down list, select Accounts Receivable (A/R).
  • In the Debit field, enter the unapplied amount being transferred. Example:$500.
  • In the Memo field, note the reason for the Journal Entry. Example: credit transfer to Martha’s account.
  • From the Name drop down list, select the customer name that credit is being transferred from. Example: Mark
  • On the second line, from the Account drop down list, select Accounts Receivable (A/R) again.
  • In the Credit field, enter the credit amount (same as debit amount). Example:$500
  • In the Memo field, note the reason for the Journal Entry. Example: credit transfer from Mark’s account.
  • From the Name drop down list, select the name of the customer that the credit is being transferred to. Example: Martha
  • Click Save.

Journal Entry
Journal Entry

Mark's Customer Page after Journal Entry
Mark’s Customer Page after Journal Entry

Martha's Customer Page after Journal Entry
Martha’s Customer Page after Journal Entry

 

The final step is to Receive Payment on both customer accounts so that it will show “Paid and Closed” customer status

From the home page screen, click Create+ sign

  • Go to the Customers tab and click Receive Payment.
  • Select the customer (example: Mark).
  • Make sure that the credit and Journal Entry are checked at the left (make no other entry on the Receive Payment form.)
  • Make sure “Amount received” show zero amount.
  • Click Save.

Follow the same “Receive Payment” steps as above for the customer (Martha).

Screenshot 2015-08-23 14.18.55
Receive Payment (Customer Mark)

Screenshot 2015-08-23 14.19.23
Receive Payment (Customer Martha)

Screenshot 2015-08-23 14.20.43
Customer Mark’s Page with Paid and Closed Status

Screenshot 2015-08-23 14.20.52
Customer Martha’s Page with Paid and Closed Status

If you liked this video, then please subscribe to our YouTube Channels (VPController and NewQBO) for QuickBooks video tutorials.

 

#QuickBooks Online

 

Categories
Journal Entry

Is there a way to download all the journal entries made in a given year? An outside auditor is asking for all the journal entries made in the previous year.

You can download “Journal” report to Excel.

There is no way download each Journal Entry one by one.

For outside auditors, customized “Journal” report may work just fine.

In order to run Journal report, from the blue navigation bar on the left

Select Reports > select “Journal” under GO to report  > select Customize button > Go to List > select “Journal Entry” under Transaction type.

Now you have record of Journal Entries only for the period you need.

See attached screenshot for reference

journal
journal

Categories
Chart of Accounts Journal Entry

How do I transfer Opening Balance of Balance Sheet Accounts? What would be the other side of accounting entry?

As a general rule, you will use the Equity accounts for one other side entry.

What you have are a possible two options.

If you are transferring, opening balance from all the Balance Sheet accounts (assets and liabilities), use Opening Balance Equity (under Equity type) account. Opening Balance Equity Account will Net out to zero once all the Balance Sheet accounts are transferred.

If on the other hand, certain opening balance accounts (like bank account) are already transferred, then you will need to review further how and where they were transferred. If you see zero balance on Opening Balance Equity Account, might as well directly transfer to Owner’s Draw or Owner’s Equity Account.

For AR opening balance, you will to reenter customer invoices again. Depending upon your accounting method (cash or accrual basis). In general, you will enter Invoice to Income Account on Cash basis; and on Accrual basis, you will enter other side of entry to Equity Account. Make sure to consult with your CPA Accountant or Tax Accountant. Exactly the same procedure also applies to AP opening balance. Journal Entry will not work.

For Inventory Asset opening balance, you will need to use Product/Services feature to enter inventory value and quantity. Journal Entry will not work.

For other Balance Sheet Accounts, couple of options available are to enter, but writing Journal Entry will also work fine.

For Opening Balance date, I prefer to use ending balance date. For example for 1/1/2014, I like to use Ending Balance date of 12/31/2013. Balance amount is still the same.

Same steps are applicable to Income and Expense accounts, especially you are transferring anytime during the year.

Categories
Journal Entry

Is there a way to mass print several hundred past journal entries which were made in Quickbooks online?

There is no way to batch print actual journal entries in new QuickBooks. In fact, there is no print button in QBO, to print actual journal entry that you see on screen at all.

To add this new feature request, add your voice here. I have already done so in the past.

http://feedback.qbo.intuit.com/

Categories
Journal Entry

How do I reverse a Journal Entry in this new QB Online?

You can reverse Journal Entry in new QuickBooks Online (QBO).
From the home page screen

  • Select Create (+) sign (upper-middle)
  • Select “Journal Entry” under Other heading
  • Select small “Clock” icon for recent transactions, next to Journal Entry form title (upper-left-corner)
  • Select Journal Entry needed to be reversed (select “More” link to expand the list if needed
  • Select “Reverse” button at the bottom middle
  • It will automatically assign sameJE# with R added. Change JE# if needed. Save
  • See screenshots below for reference

Reverse Journal Entry
Reverse Journal Entry

Journal Entry Reversed
Journal Entry Reversed

What are the mains reasons to write a reversing Journal Entry?

  • Correcting a mistake in the previously recorded transaction without deleting the original entry.
  • Reversing accrual type of Journal Entry and replaced by posting the actual transaction so that the transaction is properly reflected between two accounting periods.

    QuickBooks Tutorial – Journal Entry Debit and Credit


If you found our answers useful then please contribute a 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