The Financial Statement Export is also called the External Financial Statement or the “Bucket Statement”. This report 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” We call it “External” because Motility exports your accounting data into a spreadsheet. The report that you view is programmed into the spreadsheet.
Locate Bucket Numbers on Template
Locate Bucket Numbers on the Chart of Accounts
Viewing the External Statement
|
This functionality is NOT included in the standard Motility program. It is an additional tool that must be purchased and configured before following these instructions. Please contact your Customer Success Manager for more information. |
Set Up GL Buckets
If you are using the default Motility Chart of Accounts, the external statement bucket numbers may already be input. However, as new GL accounts are added, you will need to check the setup from time to time to ensure that the External Financial Statement remains accurate.
Locate Bucket Numbers on Template
When viewing the template, you can see the bucket numbers for each slot. These show in purple for each item.
Locate Bucket Numbers on Chart of Accounts
- Open the Reporting Module.
- Expand the Accounting Reports section.
- Expand the General Ledger Reports section.
- Expand the Dealership Financial Statements section.
- Select the Dealership Balance Sheet report.
- Choose parameters, ensuring that the Show Bucket Numbers option is set to Yes.
- Click Submit.
The first page will show the dealership financial statement. This will include the amounts from GL accounts with a bucket number assigned.
Following pages will show a list of all GL accounts that are missing a bucket number. It also shows the balance that will be missing from the External DMS until a bucket number is assigned.
Fixing Bucket Numbers
- Open the accounting module.
- Under the General Ledger tools menu on the left side of the screen, click over the Chart of Accounts option.
- Locate the account(s) you wish to update and double-click over the row to open the GL Account window.
- Add the relevant Bucket Number to the External Statement field.
- Click the Save button.
- Repeat these steps for each account that needs a bucket number added.
Viewing the External Statement
|
This functionality is NOT included in the standard Motility program. It is an additional tool that must be purchased and configured before following these instructions. Please contact your Customer Success Manager for more information. |
- Open the Accounting module
- Choose the Financial Statement Export link from the Tools menu on the left side of the screen. This will open the Financial Statement Export popup window.
- Choose the Month and Year for the report.
- Select the Company you wish to view on the report.
- Optionally, you may choose a single Profit Center to view information for solely that location. To view information for all profit centers, leave blank.
- Set the Formatting to Fixed.
- Optionally, you may check the True Turns box if you wish to view inventory as true turns.
- Click the Select Files button to navigate to the external spreadsheet DMS MASTER template. This will open a Windows navigation screen to locate the file.
- Click OK on the Windows navigation screen to select the file. This will return you to the Financial Statement Export window.
- Click the Confirm button to export the spreadsheet. This will update the spreadsheet and open it as an Excel file for viewing.
- Under the file menu in Microsoft Excel, choose the Save As option to save a copy of the file with the correct month/year information.