KnowledgeBase

How Do I Record a Debt Refinancing Where I Use a New Loan To Pay Off Several Other Loans?

Chief Mechanic · September 12, 2010 ·

A common business situation is to use a new loan to repay one or more existing loans, possibly raising cash in the process. This is commonly referred to as a refinancing.

QuickBooks includes a Loan Manager which can be run from the Banking->Loan Manager menu selection. It’s important to understand that Loan Manager is primarily a tool to calculate payment schedules and to simplify the process of distributing interest and principal payments to the appropriate GL accounts. When you create a new loan in Loan Manager, the outstanding balance for that loan will start as $0 – until you record a transaction in the liability account in QuickBooks itself. Once the liability account is increased to reflect the loan’s principal, Loan Manager can assist you to record the regular payments. Likewise, when you remove a loan from Loan Manager, you are not making changes to the liability account balance.

Therefore, the simplest way to account for a refinancing is to use GL journal entries. To make these functions, access the Make General Journal Entries window from the Company->Make General Journal Entries menu selection.

QuickBooks Premier 2009 GL Make General Journal Entries

Let’s consider this example: a company is refinancing a building for $200,000, and is using the settlement proceeds to repay 3 other mortgage loans, pay the settlement expenses, and increase cash. Each of the 3 other mortgages has an outstanding balance of $50,000, and there are 2 settlement charges that total $4,000. That produces a net increase in cash of $46,000. Here are the conceptual debits and credits to record:

Enter a credit of $200,000 to the new mortgage liability account
Enter a debit of $46,000 to the cash or checking account in which the net proceeds were deposited
Enter debits to the expense accounts to reflect the settlement charges; in our example, there are 2 debits to expense accounts, 1 for $3,000 and 1 for $1,000
Enter debits of $50,000 to each of the 3 existing mortgage accounts that were paid off with the settlement proceeds
When you’ve entered all your debits and credits, click either Save & Close or Save & New to save your work

Here’s another look at those debits and credits:

General Ledger Distribution for a Mortgage Refinancing

The order that these debits and credits are entered on the Make General Journal Entries window does not matter provided that total debits equal total credits.

Once you’ve recorded this general journal entry, you can now run Loan Manager and delete the 3 loans that were fully repaid and set up the loan payments for the new loan. Note that Loan Manager reads your GL chart of accounts when it loads, so if you’ve added any accounts while Loan Manager was already running to record the journal entries discussed, you’ll need to close and re-start Loan Manager before recording the new loan. It’s a good idea to have a separate account for each loan to simplify reconciling that account in the future, so the new loan should get a new account. The GL accounts must be active to be recognized by Loan Manager, so don’t make the GL accounts for the 3 paid-up loans inactive until after you’ve deleted them from Loan Manager.

The Account Name in Loan Manager is the liability account for the new loan, which in our example is “New mortgage liability account.” When you select this account from the pull down menu in Loan Manager, it will automatically recognize the principal balance that was created with the GL journal entries you recorded. Continue to set up the new loan and delete the repaid loans.

Once completed, your financial statements are correct, and you’re ready to use Loan Manager to calculate and distribute your loan amortization.

For more information on using Loan Manager, see our related articles on adding a new loan and deleting an existing loan.

(+1 rating, 1 votes)

When Setting Up POS for the First Time, How Do I Record the Cost of My Existing Inventory?

Chief Mechanic · September 12, 2010 ·

When setting up inventory in POS for the first time, POS will automatically enter an adjustment memo to update your inventory value when you enter a value in the Average Unit Cost or the On-Hand Quantity fields when adding a new item. Before doing so, a message will pop up asking you to Continue or Cancel Edits to the field that prompted the pop up message. Click Continue. During first time setup, you’ll be recording both an On-Hand Quantity and an Average Unit Cost, so you’ll see the pop up message at least 2 times. When you save the item, POS will automatically record an adjustment memo for your starting inventory valuation and quantity for that item. In this example, we’ll record 10 units of a new item at an Average Unit Cost of $12.00.

QuickBooks POS 8 New Item Average Unit Cost

Let’s carry our analysis one step further to see how to record new receipts of an item following our initial setup.

Once you’ve recorded your initial On-Hand Quantity, click the Receive Items button to record a New Receiving Voucher for 1 or more items. In the New Receiving Voucher window, you record the Qty (the quantity received) and the Voucher Cost (the cost for the latest delivery). Simply click in the field to change the default value. In the example below, we’ve recorded a receipt of 10 units at a cost of $5.00.

Because the new $5.00 cost is considerably lower than our original cost of $12.00, POS will pop up a message advising us that the latest voucher has a different cost than our existing inventory and give us a chance to review the pricing for that product. We’ll review product pricing at another time and click No, I’ll Review Prices Later.

To summarize, our initial inventory during first setup of POS consisted of 10 units that cost $12.00 each. Following setup, we vouchered a receipt of an additional 10 units at $5.00. Since QuickBooks and POS operate on the average cost method, our new Average Unit Cost for this inventory item is $8.50, or ( ( 10 units X $12.00) + (10 units X $5.00) ) / 20 units.

(No Ratings Yet)

How Do I Change an Onscreen Form Such As Create Invoices To Show More Line Items?

Chief Mechanic · September 12, 2010 ·

Making changes to the windows of QuickBooks is easy.

Let’s use the Create Invoices window as an example. By default, this window shows just 2 invoice lines. In this article, we’ll change the default look. An important point to keep in mind is that you should not close the Create Invoices window until you’ve completed all the steps in this article. Otherwise, you’ll lose your work and need to start over.

Here’s the Create Invoices window in its smallest form. Pay close attention to the right border. We’ve positioned our mouse pointer directly on the border, and it’s now turned into a left-right arrow. It only provides this functionality when your mouse is positioned directly on the border; if you move it off the border, your pointer shape and function will change.

QuickBooks Premier 2009 Create Invoices Right Border

With your mouse pointer positioned directly on the border, make the Create Invoices window bigger by dragging this border to the right. To drag something in Windows, hold down your primary mouse button while moving it to the desired position. Since we started with the smallest form, we can’t drag it to the left. Next, drag the bottom border down and watch more invoice line items immediately appear. Re-size the window to fit your needs.

Let’s carry our customization 1 step further. Position your mouse directly on the fine line between any 2 columns, such as the one between U/M and Rate. Your mouse pointer will change to another type of left-right arrow.

QuickBooks Premier 2009 Create Invoices Column

To change the width of a column, drag the pointer when it’s positioned directly on the line between 2 columns and is in the shape shown above. Again, it only provides this functionality when your mouse is positioned directly between 2 columns; if you move it away from this position, your pointer shape and function will change. One common need in re-sizing a window such as the Create Invoices window is to increase the width of the description field. With this knowledge, that’s now an easy task. Re-size any column to suit your needs.

Once you’ve completed customizing the look of your Create Invoices window, you need to save your work. To do that, do not close the Create Invoices window. Instead, go to the Edit->Preferences menu, and choose Desktop View from the submenu shown. Since QuickBooks can store different desktop settings for individual users, be sure you’re on the My Preferences tab.

QuickBooks Premier 2009 Preferences Save Current Desktop

Click the radio button Save current desktop and click OK. Your changes to the Create Invoices window are now saved. To confirm that, close the Create Invoices window and re-open it. It should now open to your customized size and layout. Since you’ve just saved your desktop with the Create Invoices window open, that window will open the next time you start QuickBooks. If you want different windows to open by default, simply open them and save the desktop in that state.

This same technique can be applied to most, if not all, data entry screens in QuickBooks.

(+2 rating, 4 votes)

How Do I Record the Sale of a Fixed Asset On a Lease?

Chief Mechanic · September 12, 2010 ·

If you’ve already accounted for a leased asset as a fixed asset, you’ve accounted for that asset as a capital lease, sometimes called a finance lease, as opposed to an operating lease. We’ll assume that the capital lease determination is correct and proceed from that point.

Capital leases impact a firm’s balance sheet, and the gain or loss from the disposition of these items flows through to the income statement. However, the gross amount from the sale of fixed assets is not revenue or income and should not be recorded in accounts that record results from operations.

Let’s imagine a company with a computer that had an original cost of $1000 and has accumulated depreciation of $500. The company is selling the computer for $200 and will use the $200 to reduce the lease liability. In effect, the firm has a computer that has a net carrying cost of $500 ($1000 cost less $500 accumulated depreciation) that is being sold for $200, or a loss of $300. Conceptually, here are the journal entries that should be made:

Step 1: Record the Asset Sale

General Journal Entries for Sale of Leased Asset Step 1

Step 1A: Record the Asset Sale and Use Make Deposits Window to Record the Cash Receipt

General Journal Entries for Sale of Leased Asset Step 1a

Step 2: Record Using the Sale Proceeds to Repay the Lessor

General Journal Entries for Sale of Leased Asset Step 2

Step 1 removes the computer (the fixed asset) from the balance sheet and reverses the accumulated depreciation against that asset. It also records the cash receipt and the resulting loss. If you elect to enter the cash receipt in the Make Deposits window (Banking->Make Deposits), you would select your computer asset account as the From Account. In that case, since QuickBooks would automatically debit cash for $200 and credit your asset account by $200 (of the $1000 total), you’d make the alternate journal entries in Step 1A to complete recording the asset sale. Note that the “Loss on sale of assets” account is an Other expense account. To create an account of this type, use the Other Account Types selection and choose Other expense from the pull down menu.

The journal entries in Step 2 do not need to be directly entered. Those are the journal entries that QuickBooks will create when a check is written to the lease liability account.

(+1 rating, 1 votes)

What Does the Error “The File You Specified Cannot Be Opened. Make Sure That It Is Not Currently Being Used By Another Program Or A Read-Only File. The Windows Error Is: The File Exists” Mean?

Chief Mechanic · September 12, 2010 ·

According to Intuit, the error “The file you specified cannot be opened. Make sure that it is not currently being used by another program or a read-only file. The Windows error is: The file exists” indicates that QuickBooks has encountered a problem reading a file. There are several situations under which the error can occur. The cause and fix therefore varies.

If you were attempting to print a form, according to Intuit the error is most likely caused by a changed file attribute on the file QBPRINT.QBP to any attribute other than archive.

In the error occurred in that setting, consult this Intuit knowledge base article for specific steps to resolve it.

If the error occurred in a situation other than attempting to print a form, according to Intuit the error is caused by a problem reading the company file or tax form files. The error may occur when running under Microsoft Windows Vista. There are several possible fixes:

turn Vista User Account Control (UAC) off, restart, then turn UAC back on, and restart again
verify the folder permissions on the upper level program folder, as in C:Program FilesIntuit
repair your QuickBooks installation

For the specific steps to resolve this error in this setting, consult this Intuit knowledge base article.

(-3 rating, 5 votes)

KnowledgeBase

Accounting

Developer

Intuit