Skip to main content

Ledger Setup

Ledger Setup is the ledger of one company. It names the fiscal calendar the company's years come from, the chart of accounts it uses, its local and reporting currencies with their exchange categories, and, by account range, which dimensions a voucher line must carry. Nothing posts in a company until its ledger exists.

Where
General Ledger › Controlling › Ledger Setup
Who uses it
The implementation consultant
When
Once, when the company is set up

What it is for​

Every amount in Businessflo is kept three times: in the document's currency, in the company's local currency, and in the reporting currency. This screen sets the last two, and the exchange categories whose rates convert to them.

The rule people get wrong: the Local Exchange Category is the one whose rates are read everywhere. A rate keyed under another category on Currency Conversion is never found.

Every field in plain words​

FieldWhat it meansWhat to put
Legal EntityThe companyRequired. One ledger per company. Cannot be deleted when Predefined
Legal Entity CalendarThe fiscal calendarRequired. The company's years and periods are those of the Financial Year records of this calendar
Account ChartThe chart of accountsRequired. Accounts released to the company come from this chart
Local CurrencyThe company's own currencyRequired. Changing it clears the exchange categories
Local Exchange CategoryThe rate table used to convert to local currencyRequired
Reporting CurrencyThe currency of group reportingRequired. Same as local currency when there is no group reporting
Reporting Exchange CategoryThe rate table for reporting currencyRequired. Locked to the local one when both currencies are the same
Budget Exchange CategoryRecorded only
Balancing Financial DimensionThe dimension every voucher must balance by, such as business area or siteOptional. See below

Account Structure tab​

Each line gives a range of account numbers a set of dimensions.

FieldWhat it meansWhat to put
Range from, Range ToThe account numbers coveredRequired
Account StructureThe set of dimensions those accounts carryFrom Account Structure. Required, except on a line covering 1 to 9999999999
Value ConditionsThe values each dimension may take on these accountsOpens a sub-grid with one column per dimension of the structure. Several values separated by commas are allowed
Line TextTextOptional

On Save the system writes the allowed values to every account of the company in each range. General Entry then refuses a line whose dimension value is not allowed, and a line that leaves a mandatory dimension empty.

Exchange category per module tab​

Module and Exchange Category per line. Recorded only.

Several units in one company​

Fill Balancing Financial Dimension when one company keeps several units (business areas, sites, plants) and each must balance on its own. On Save the system creates the dimension "affiliate" and two account structures, BAL-FIN-DIM and INTERUNIT, if they do not exist, and adds two kinds of lines here: one over the whole account range with the balancing dimension, and one for each inter-unit account set on Automatic Transaction. Clearing the field removes those lines.

Scenarios​

  • A single company in one currency. Local and reporting currency the same; one exchange category for both.
  • A subsidiary reporting to a parent abroad. Local currency the subsidiary's; reporting currency the parent's. Every voucher line carries both amounts.
  • A distributor with three branches in one company. Balancing Financial Dimension = business area; inter-unit accounts on Automatic Transaction.

What it is connected to​

If something looks wrong​

  • "Lineid: ... - Account Structure cannot be empty" Pick an account structure for the range.
  • "Ledger Setup - cannot delete this Ledger as it's predefined" The delivered ledger stays.
  • "Chart of Account is not defined for this Legal Entity." on an account screen: the company has no ledger, or no Account Chart on it.
  • "Financial Year not found." on a document: no Financial Year of this calendar covers the date.