Go through each item on the GL Mapping sheet. Check it against your data extract to be sure you imported the correct balances. Carefully review the imported information for errors.
Does it look accurate? Are positive numbers positive and negative numbers negative? Did you remember to include all of the general ledger codes needed for each category?
Don't be discouraged if further modification is needed - this is a normal part or the set-up process. If additional changes are needed, simply go back to the GL Mapping Sheet and continue editing your general ledger codes as needed.
If you are having difficulty:
Review the "Understanding Asterisks, Plus Signs and More" section
In some DP system extracts, when trying to get year- to-date income, this may be the answer: -1*-2*-3*-4* (year-to-date income and expenses together generate year-to-date income).
Test, test and test again. Run an import frequently to see how the changes you are making in the GL Mapping sheet are affecting your imported income.
Remember - you only have to perform this setup process one time, and then you'll be able to easily import your data into Insight every month.
NEXT: Tutorial - Setting Up the GL Mapping Sheet