Come up with a report for Depreciation expense per month with the details

Customizing the Income Statement Summary would only allow customers to see the total balance posted against depreciation and amortization expense or any other nominal accounts per accounting period. Also, customizing the Income Statement Detail Report would show the transaction details but you cannot customize it to allow you to view it per period.

To come up with a report for Depreciation and Amortization expense per period with the details and the balance is in sync with the Income Statement Report, follow the steps below:

1. Navigate to Reports > New Report > select Transactions on the list.

2. Set the following on the New Transaction Report Name :
--Report Title = any preferred name
--Metric = Amount
--Select the format of the report = Matrix
--Select how you want to subtotal the report = Account.
--Hit the More Customization button.

3. You will be redirected to the Report Builder page.

4. On the Edit Columns tab, take note of the following:
-- Remove the Name column.
-- Add the following fields by typing it in the search box or expanding the available folders:
a) Name (GL-style) > open this by expanding the Account folder. Mark the Group box for this column.
b) Date > type it in and select the first Date result.
c) Transaction Type
d) Transaction Number > type it in the search box and select the first result.
e) ID > open this by expanding the Transaction folder, then Entity (line).
f) Set the following for the Amount column.
--Summary = Sum
-- Add Grand Total = True
-- Alternate Period Range Type = Relative to report date
-- Alternate Period Range = Custom
-- Select Jan 2011 under Periods.
g) Add the Amount field 12 times for Feb 2011 to Dec 2011 and for the total. To add the amount column, type in Amount in the search box and select the first result. Follow the setting on item f and just set the correct period for Feb 2011 to Dec 2011. For the total amount column, highlight Jan 2011 to Dec 2011.

5. On the Filters tab, add Account Name (expand Account folder and select Name) as one of the Filters. Add all the Amortization and Depreciation account by typing in Amortization, then Depreciation on the Search box on the account drop down.

6. Hit Done.

7. On the Sorting tab, remove all existing sort order and add the following:
--Name (GL-style)
--Transaction Number> type it in the search box and select the first result

8. Set a specific name for the report under the Name field.

9. Hit Save.

10. To access the newly saved report, navigate to Reports > Saved Reports > All Saved Reports > select the report name.