We used to have 2 "consolidating" companies setup that we used to enter all of our yearend consolidation/elimination entries.Did you ever have any luck with your consolidation problem?The sum of debit side amounts should equal to the sum of credit side amounts.A journal entry is called "balanced" when the sum of debit side amounts equals to the sum of credit side amounts.The Consolidation Accounting Series for Microsoft Dynamics GP® and Management Reporter provides successful design concepts and step-by-step guides.The purpose of our â€œConsolidation Design in Microsoft Dynamics GP and Management Reporterâ€ White Paper is to provide successful design concepts for performing Consolidation Accounting using Microsoft Dynamics GP and Management Reporter.
To record transactions, accounting system uses double-entry accounting.
The purpose of our Currency Translation in Microsoft Dynamics GP® and Management Reporter White Paper is to provide the step-by-step setup requirements for performing multicurrency consolidation in Dynamics GP and Management Reporter.
The purpose of this White Paper, the 3 White Paper in the Consolidation Accounting Series for Dynamics GP, is to provide design concepts for performing Elimination and Adjusting entries using Reporting Ledgers for Consolidation Accounting in Microsoft Dynamics GP and Management Reporter.
Hi all (especially the Accountants in the group), I'm searching for an Excel General Ledger which our Accounting staff can use to do all of the yearend consolidation entries. We switched software systems and were told that we have to use Excel to do any of the yearend consolidation/elimination entries.
I might take on the challenge and use some VBA to do the validation (ex: preventing the fle from being saved/printed unless the debits equal credits, etc.), but I don't want to re-invent the wheel unless it's necessary. I have been asked to research the options available to us using Excel. Hi, I came across this post that you posted a couple of years ago.