Accounting Seed leverages the Salesforce Report and Dashboards functionality for detail level reporting. For example, drilling down into the General Ledger, doing revenue or cost analysis, project profitability reporting, purchase order status, and many more. However, high level financial statements such as a Balance Sheet, Profit and Loss, and Trial Balance will all be run from Accounting Seed’s own tool, Financial Reporter.
When Accounting Seed is installed, two new folders will be included: Accounting Reports and Accounting Dashboard.
- Included in Accounting Seed, the Accounting Reports folder contains the Billing Aging reports by Customer. These reports are used to manage A/R and do collections.
- Historical (Period Sensitive) Billing Aging is what is used to reconcile the A/R Control balance at the end of each month. This report looks to the Billing Aging History object to understand the balance on each outstanding Billing at the end of an Accounting Period.
- Current Billing Aging report is typically used to manage collection activities and shows the A/R balance at the moment it is run.
- A Billing record has one or many Billing Lines. These two objects are set up in a Master-Detail relationship and behave just as any other Master-Detail relationship on the Force.com platform.
- The Billing Line also has Lookup relationships to the Product, Project, Project Task, 4 GL Variables, and the GL Account objects.
- Included in Accounting Seed, the Accounting Reports folder contains the Payables Aging reports by Vendor. These reports are used to manage A/P.
- Historical (Period Sensitive) Payable Aging is what is used to reconcile the A/P Control balance at the end of each month. This report looks to the Payable Aging History object to understand the balance on each outstanding Payable at the end of an Accounting Period.
- Current Payable Aging report is typically used to manage collection activities and shows the A/P balance at the moment it is run.
- A Payable record has one or many Payable Lines, these two objects are set up in a Master-Detail relationship and behave just as any other Master-Detail relationship on the Force.com platform.
- The Payable Line also has Lookup relationships to the Product, Project, Project Task, 4 GL Variables, and the GL Account objects.
- The Project and Project Task objects are a Master-Detail pair of objects used to allow customers to track revenue and cost to a “Project.” A Project is usually an event, a job, or perhaps a grant in a non-profit organization.
- As the Project and Project Task are available to be included on every source object, this data flows through to the Transaction object and is available for full Profit and Loss level reporting via the Salesforce reporter.
- The Project and Project Task objects behave as any custom object on the Force.com platform and are often customized to suit the customer's unique business process.
- If a customer elects to use Time Card and/or Expense Report functionality in Accounting Seed, Projects and Project Tasks are required for that functionality to work.
Sales Order Reporting
- Reports most commonly generated around Sales Orders are targeted at understanding what Sales Orders are completely allocated and which are not. This is a good indicator of product demand.
- The Sales Order and Sales Order Lines do not create any Transaction records (debits or credits) in Accounting Seed. However, they do impact the Inventory Quantity on hand of a particular product.
- Depending on the business model reports connect Sales Orders and:
- Shipments can be useful to understand if items have shipped.
- Billings can be useful to understand if Sales Orders have been Billed.
- Purchase Orders can be useful to understand if product has been ordered to demand.
Purchase Order Reporting
- Reports most commonly generated around Purchase Orders are targeted at understanding what Purchase Orders are received or not, or paid or not. This is useful for inventory management and cost assessment.
- When an inventory Product is received (Receive button on the Purchase Order) it generates a Purchase Order Inventory Movement and in turn Transaction records.
- Depending on the business model reports connect Purchase Orders and:
- Payables can be useful to understand if the Vendor has issued an invoice for the PO.
- Sales Orders can be useful to understand if product has been ordered to demand.
- Projects can be useful to understand what has been ordered and received for a Project.
- PDF - Numeric Formats field on PDF Formats(Dallas)
- Discontinued Integrity Reporting(Dallas)
General Ledger Reporting
Detail Level Reporting
- The General Ledger in Accounting Seed is represented by the data in the Transaction object. This object contains every debit and credit made by Accounting Seed source records.
- It is tightly controlled by code preventing any edits, deletions, inserts, or updates, unless they are from Accounting Seed code. Consequently, it is a very powerful object to report on for detail level inquires and analysis.
- The transaction object receives entries from the 13 source objects in Accounting Seed and they are as follows:
- Billing Line
- Billing Cash Receipt
- Cash Receipt
- Payable Line
- AP Disbursement
- Cash Disbursement
- Journal Entry Line
- Amortization Entry
- Time Card Day
- Purchase Order Inventory Movement
- Inbound Inventory Movement
- Manufacturing Inventory Movement
- Outbound Inventory Movement
- Each Transaction record has lookups to many Accounting Seed objects such as: GL Account, each of the 4 GL Variables, Project, Project Task, its source record, and where appropriate the Salesforce Account and Product records.
- Included in Accounting Seed, the General Ledger report folder contains several reports to assist users in analyzing the Transactional Data. The Transaction Detail by GL report is a very versatile report and a great place to start for any customer learning Accounting Seed reporting.
Summary Level Reporting
- Financial Cubes are an aggregate mechanism to enable month end reporting in a more timely manner, and are generated as transactions occur but updated and maintained during the opening and closing of an Accounting Period.
- A Financial Cube aggregates all Transactions around the unique combination of the following objects:
- Accounting Period
- GL Account
- Each of the four GL Variables
- Financial Cubes are the basis for all Accounting Seed Financial Statements and so are leveraged by the Accounting Seed Financial Reporting tool.
- Financial Cubes are accessible for reporting through the Salesforce Report tool.
- Financial Cubes are used to load high-level budget data, to allow both budget and actual data to be displayed in the Financial Statements.
- The Accounting Seed Financial Report tool generates the following Financial Statements from the Financial Cube records:
- Balance Sheet
- Profit & Loss
- Profit & Loss vs. Budget
- Trial Balance
- Cash Flow Statement
- These Financial Statements come with the package and can be downloaded into Excel or printed directly from the tool to a PDF.
- By default, they will run for all the organizational data, but can be filtered by any of the four GL Variables to show Profit & Loss for a particular Business unit for example.
- In a multi-company environment, a user can also select which company they want to run a report for.
- Once a report is generated, a user can further drill down into any number on that report and then back to the source transaction.
- A user can also define their own Financial Statement Definitions, which allows them to build their own custom report defining the specific columns and rows at a GL Account level or group several GL Accounts together to aggregate detail data.
Print a full listing of all Accounting Seed features.