Skip to main content

DMS Statement- Internal

  • Updated

The Internal DMS statement or “Bucket Statement” allows the chart of accounts to be combined into “buckets”. For example, you may have three bank accounts combined into one bucket called “Cash In Bank” This makes financial statements like the balance sheet and P&L easier to read for banks, partners, and owners.

Viewing the Statements

  1. Open Reporting Module
  2. Expand Accounting Reports
  3. Expand General Ledger Reports
  4. Select Dealership Financial Statements
  5. Select Dealership Balance Sheet
  6. Click Show Report(s)

1-76-e1548739491209.png

Setup

If you are using the Motility Chart of Accounts, the internal statement may already be set up by default. However, as new GL accounts are added to the chart, you may need to check the setup from time to time. This is necessary to ensure that the Internal DMS statement is accurate.

  1. Open Reporting Module
  2. Expand Accounting Reports
  3. Expand General Ledger Reports
  4. Select Dealership Financial Statements
  5. Select Spreadsheet Bucket Numbers
  6. Click Show Report(s)

2-72-e1548739442676.png

This report shows which bucket numbers correspond to which location on the Internal DMS Reports.

3-60.png

The second report shows the bucket numbers for the Internal DMS P&L. Notice that all Revenue accounts are in bucket 1002 and all Cost accounts are in bucket 1003.

4-48.png

Now that you know which bucket number corresponds with which location on the DMS, you can modify the labels next to each number by clicking on Modify Bucket Descriptions on the same report.

5-40-e1548739396330.png

You can customize the labels on this page.

6-32.png

The next step is to find out which GL account is assigned to which bucket. You can audit this periodically by running the following report

  1. Open Reporting Module
  2. Expand Accounting Reports
  3. Expand General Ledger Reports
  4. Select DMS Detail Report
  5. Select Report Style “Internal Statement Bucket”
  6. Click Show Reports

7-25-e1548739214546.png

The first Internal Bucket is an audit for all GL accounts missing bucket numbers. If a GL account does not have a bucket number assigned, it’s balance will not show up on the DMS statement.

8-20.png

Then the report shows each bucket number and its total balance. Within each bucket number, every GL account included in the bucket is shown with its individual balance.

9-18.png

To change the bucket number on a GL account, open Edit > Modify > Add/Modify GL Accounts.

10-16.png

The Internal Statement number is the bucket number

11-13.png

Related articles