There are different ways to get the data you want, WM2. You can either customize the report or export it to Excel.
I'll use the Balance Sheet Standard report as an example. Here's how you can customize it to show the account's CP, PP, CP vs PP, Current YTD, Previous YTD, and their Variance:
- Click Reports at the top and select Company & Financial.
- Select Balance Sheet Standard.
- Click the Customize Report and go to the Display tab.
- Under the COLUMNS section, mark the following boxes:
• Previous Period and $ Change
• Previous Year and $ Change.
- Click OK.
This should display the information you need.
I am curious of what report did you use. Depending on the report, I might be able to provide different customization steps.
Additional details about this would be much appreciated.