4. Sending allocation Journal Entries to QuickBooks

Top  Previous  Next

 

In this topic:

 

Sending Journal Entries to QuickBooks

1.Click the Send button in the main toolbar, then follow the prompts.

 That all there is to it. When the process has finished—it takes just seconds—all of your ManagePLUS Gold allocations will be represented in QuickBooks as Journal Entries.

Things to know:

The JEs created in QuickBooks will be dated as of the last day of the active accounting period.
ManagePLUS Gold may update the QuickBooks Chart of Accounts before it sends the JEs. (See What goes on behind the scenes, below, for details.)
To see the JEs before sending them, look at the Seeing your allocation transactions in ManagePLUS Gold topic in the Miscellaneous Ideas & Tasks section.

Updating allocations and re-sending the Journal Entries

Suppose you've created allocations in ManagePLUS Gold and sent their Journal Entries to QuickBooks. But later you edit some transaction amounts on which the allocations were based. Or maybe you decide to change allocation percentages or methods, or change some of the management quantities referred to by your allocation setups. How can you update your allocations?

1.Open ManagePLUS Gold to the desired accounting period.

 By default, it opens to the same period you worked with last time.

2.Refresh transactions from QuickBooks.

 This step is only necessary if you've made any transaction changes in QuickBooks, for the period.

3.Change your allocation setups or management quantities, etc., if desired.

 This step is optional. If you only need to update allocations due to changes in the transaction amounts they are based on, you may leave your allocation setups unchanged:  ManagePLUS Gold will automatically re-apply them to the updated transaction amounts.

4.Send Journal Entries to QuickBooks again.

 ManagePLUS Gold will delete the old JEs and replace them with updated ones.

What goes on behind the scenes (the technical stuff)

When you click on the Send button to send Journal Entries to QuickBooks, ManagePLUS Gold:

1.Deletes old allocation transactions from QuickBooks, for the active accounting period.

 This assures no old transactions (created by ManagePLUS Gold) exist in QuickBooks within the dates of the active accounting period. Transactions outside the active accounting period's date range are ignored.

2.Synchronizes with the QuickBooks Chart of Accounts.

 When you add or change allocation formulas, ManagePLUS Gold builds a new set of allocation transactions. But before doing that, it creates accounts in the Chart of Accounts window, as needed, to mimic the cost center and profit center classes involved in the allocations. These ManagePLUS Gold-created accounts are added to the QuickBooks Chart of Accounts before transactions are sent. (In some cases, ManagePLUS Gold-created accounts may be deleted or renamed.)

 See How ManagePLUS Gold updates the QuickBooks Chart of Accounts, below, for details.

3.Sends the transactions.

 This is the simplest part of the process. With old transactions deleted and the necessary accounts in place, ManagePLUS Gold simply sends the allocation JE transactions to QuickBooks.

How ManagePLUS Gold updates the QuickBooks Chart of Accounts

It handles updating of the QuickBooks Chart of Accounts automatically.
It creates, renames, and manages a group of Other Expense type accounts, with an account named Allocated Expense (MP) as the parent account, and a single level of subaccounts below it.
It manages the names of these subaccounts and may rename them at any time, so that their names always correspond to the classes they represent.
While you may rename these subaccounts' in QuickBooks, your renaming may be temporary. If you later change any class names, and those classes are involved in allocation, ManagePLUS Gold will rename the corresponding subaccounts to correspond to the names of the classes they represent.
You may freely rename the the Allocated Expense (MP) account, and ManagePLUS Gold will leave the new name unchanged.

How Allocated Expense (MP) subaccounts are named

The names of these subaccounts mimic the "path" to the classes they represent. So if you have a class named:

         Equipment:Fork Lifts

ManagePLUS Gold will create a subaccount named:

         Equipment_Fork Lifts

(An underscore (_) is substituted for the colon (:) which separates the class name levels.)

What identifies ManagePLUS Gold transactions in QuickBooks?

All have "MP~" in their Reference Number and Memo fields.
Do not use "MP~" in the Reference Number or Memo fields of your own transactions, or ManagePLUS Gold may delete them as part of managing its own transactions in QuickBooks.