Ledger & Banking Features Overview

Overview

This article describes the functions and capabilities of Accounting Seed's General Ledger and Banking feature sets. Please visit the General Ledger section of this knowledge base or Accounting Seed University for more comprehensive training. 

Journal Entries

Journal Entries are used in Accounting to make adjustments or record items that don’t originate from any of the source objects in Accounting Seed. A common example is a payroll journal entry.

• Journal Entries can be created and posted later to allow for an approval process to happen, or created and posted all in one step.
• Accounting Periods can be batch opened and closed.
• If a user is creating a Journal Entry and selecting the AR Control GL account, then they must also select a Customer (Account). If they are selecting the AP Control GL account, then they must select either a Vendor (Account), Contact, or User.

Multi-Company

Multi-Company allows an organization to track financials for more than one legal entity in a single Salesforce/Accounting Seed instance. 

• Allows businesses to track multiple companies in a single Salesforce instance provided all the companies have the same:
• Fiscal year end
• Chart of Accounts
• Supports multiple legal entities in a single Salesforce instance with different base currencies (i.e. Multi-Nationals).

Multi-Currency

For businesses who need to invoice customers or pay vendors in other currencies than their own, they will want to elect to use Accounting Seed’s multi-currency functionality.

• Enables an organization to invoice customers and receive payment in any foreign currency.
• Enables vendors to be entered and paid in any foreign currency.
• Enables Journal Entries to be entered in any foreign currency.
• Automatically tracks any “realized gains or losses” due to currency exchange rates, this is necessary when managing the reporting in a customer's base currency. The ledger will track both the foreign amount and the converted amount of all foreign currency transactions.
• Accounting Seed uses Salesforce currencies to support this feature.
• Customers must have one base-currency which they will produce their financial reporting in
• Customers must also elect to use Salesforce advanced currency management for dated exchange rates functionality to use this feature.
• Bank Deposits and Bank Reconciliations can be processed in foreign currencies.

Fixed Assets

Accounting Seed allows for a user to set up a Fixed Asset and track data on its useful life. Examples like company trucks or machinery are good candidates for Fixed Asset items.

• An automatic function exists to allow a user to set up a series of entries to depreciate the asset over months in the future
• Accounting Seed supports straight-line depreciation.

Budget Entry

Accounting Seed’s transactional data is stored in a Ledger called Actual. You can create any number of additional Ledgers to track Budget data.

• High-level budget data can be uploaded into Accounting Seed to be used in comparison to actual data in a Financial Statement.  
• Budget to Actual view is pre-configured as part of the Financial Reporter.
• This data is populated as records into the Financial Cube object related to a Budget ledger, so it needs to be aggregate data by the Accounting Period, GL Account, and GL Variables.
• Project Budget data can also be tracked, however, this is tracked in the Project Accounting set of functionality on the Project Task object. Project Budget data cannot be reported on with the Financial Statement tool, but rather in a Salesforce report.

Financial Reporting

Accounting Seed has 3 reporting tools: Financial Reporter, Management Reporter, and Dashboards.

• The Financial Reporter includes the following list of standard reports. All of the reports have drill down to transaction level and can be exported to Excel or to a PDF file. 
  • Profit and Loss
  • Profit and Loss Versus Budget
  • Balance Sheet
  • Trial Balance
  • Cash Flow Statement
• The Financial Reporter also includes the capability to create custom reports with your own rows, columns and calculation. Custom reports also support drill down
• The Management reporting tool provides transactional reports throughout the application. It has a drop and drag interface and supports charting and drill down as well. About 30 management reports come built for you when you start a new instance. Management reports can be scheduled automatically for email distribution
• Accounting Seed includes flexible drag and drop Dashboards. A sample dashboard is included with new instances. Dashboards also have drill down to transaction level data.

Bank Deposits

A collection of Cash Receipts and Debit Journal Entry Lines (often used to record bank fees/refunds) can be associated together to form a Bank Deposit record.

• Bank Deposits allow you to record the amount of money deposited at one time and makes doing Bank Reconciliations much easier.

Bank Reconciliations

A Bank Reconciliation is a tool to make sure that all deposits (Cash Receipts or Bank Deposits), withdrawals (Cash Disbursements), and adjustments (Journal Entry Lines) are recorded in Accounting Seed and show up on your General Ledger.

• Accounting Seed’s Bank Reconciliation is done for a specific Bank/Credit Card Account (GL Account) and a specific date range; it doesn’t have to be done for a month although that is a common practice.
• Bank Reconciliation reports can be printed once the Bank Reconciliation is complete to show all cleared and uncleared transactions for audit and follow up.

Bank Direct Connect

The Bank Direct Connect (BDC) tool is an integration using a third party bank aggregation service that allows a user to pull transaction history from a connected bank or credit card account directly into Accounting Seed.

• The Bank Direct Connect tool is connected to over 14,500 financial institutions. If a customer’s bank is not supported by this service, Accounting Seed provides the Financial File Import wizard with very similar functionality.
• All of the features for the Bank Direct Connect tool are in one centralized location, including the Bank Settings, Bank Transactions, Bank Rules, and Financial File Import.
• Downloaded Bank Transaction records are automatically created within Salesforce. Therefore, you do not have to reconnect to a bank each time you need to review transactions.
• Bank Rules allow you to control how to auto-populate fields on source records created from BDC through user-defined rules.
• Bank Direct Connect allows you to automatically add or match Bank Transactions to source records.
• The Financial File Import wizard provides the ability to import foreign Bank Transactions. Source records created from foreign Bank Transactions or matched to them will be in the same currency as the foreign Bank Transactions, while the GL Transactions created from the source records will be converted into the currency of the Ledger.
• Bank Direct Connect can create a Cash Receipt, a Cash Disbursement, a Debit Journal Entry, or a Credit Journal Entry. These records can be assigned to Customers, Vendors, GL Accounts, GL Variables, Projects, and Project Tasks at the time of entry making data entry of electronic transactions very easy.

____________________

Release Notes and Schedule

• The new Financial Reporter is available with the Lily release.
• The Lily flower was updated on the graphic.