Business Central Basic Finance Training
Table of Contents
System Setup
1) Company Information
2) General Master Tables
a. Payment Method
b. Payment Terms
c. Item Charge
3) Currencies and Exchange Rate
4) Dimensions
5) Chart of Accounts
6) Posting Groups
7) No. Series
8) Accounting Period
9) General Ledger Setup
10) Sales & Receivable Setup
4) Purchase & Payable Setup
5) Inventory Setup
6) Fixed Assets Setup
7) Marketing Setup
Master Setup
1) Customer
2) Vendor
3) Employee
4) Item
a. Create New Item
b. Inventory Type
c. Copy Item Function
d. Item Template
5) Bank Account
6) Fixed Assets
Analysis View
Account Schedule
1) Account Scheule Layout
2) Create Column Layout
3) Create Account Schedule
Finance Operation
1) General Journal
2) Account Receivable
3) Payment Journal
4) Recurring General journal
5) Reverse Entry
Pages
1) G/L REgister
2) General Ledger Entries
3) Customer Ledger Entries
4) Vendor Ledger Entries
5) Bank Ledger Entries
6) Reports
Month End & Year End Closing
1) Month End
2) Year end
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
Tab | Setup Information |
General | Company Name, Address etc |
Communication | Contact Information such as phone no, Email etc |
Payments | Choose "Allow Blank Payment Info." for allow create sales invoice without filling setup fields in Company Information |
Shipping | Set up for the default ship-to address for the company |
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
- Payment method code and payment method description
- Balance account – use for default settlement account.
Anchor | ||||
---|---|---|---|---|
|
Due Date Calculation Formula
• D = Day(s)
• M = Month(s)
• CM = End of Current Month
Example:
...
For more information on date formula use in Business Central, please see Entering dates and times in Business Central - Business Central
Anchor | ||||
---|---|---|---|---|
|
i) Set up item charge for include the additional cost (e.g. Freight charge) to the inventory value.
...
For more information on Item Charge, please see https://docs.microsoft.com/en-us/dynamics365/business-central/payables-how-assign-item-charges
Anchor | ||||
---|---|---|---|---|
|
To Create Currency
- Go to Currencies List
- Select New on Action Bar
- Fill up the basic information as below.
...
Example: 1 HKD = 7.8 USD (Local Currency: HKD)
Anchor | ||||
---|---|---|---|---|
|
To create new Dimensions
- Go to Dimensions List
- In Edit List mode, enter the new dimension code into the last row or click new to add the new dimension.
To add Dimension Values for the Dimension
- Go to Dimensions List
- Select the Dimension that you want to add dimension values.
- Select Dimension, Dimension Values in Action Bar
- Enter the Dimension Value Code and Name
To set up the new dimensions as global or shortcut dimensions
- Go to General Ledger Setup page to set up the global/shortcut dimension.
Important: Changing a global or shortcut dimension requires that all entries posted with the dimension are updated. To change a global dimension, use the Change Global Dimensions function, but it can be time-consuming and may affect performance and tables may be locked during the update. Therefore, choose your global and shortcut dimensions carefully so that you do not have to change them later.
Setup Default Dimensions for Customer, Vendor, Item and G/L Accounts
- Value Posting Options: Code Mandatory, Same Code, No Code
If you want to make a dimension required but you do not want to assign a default value to the dimension, leave the Dimension Value Code field blank and then select Code Mandatory in the Value Posting field. Table below shows the example:
Module
No.
Dimension
Dimension Value
Value Posting
Customer
C00086
CUSTOMER
C00086
Same Code
G/L Account
610600
COST CENTRE
Code Mandatory
Chart of AccountsAnchor _Toc69205325 _Toc69205325
Chart of Accounts List
- Use [Filter list by] to preview specific G/L account
- Use [Filter totals by] to filter the balance by Global Dimension or Specific Date
- Balance and Net Change
- Balance is the total across accounting period.
- Net Change is the total for date filter input in Filter totals by.
G/L Account Category / Account Sub-Category
- User can set up account category for generate the account schedule for financial statements.
- Top-level account category such as Assets, Liabilities, Equity, Income, COGS and Expenses are fixed. User can add or delete lower levels categories.
- G/L Account Categories List
- Select Edit List action to add or edit G/L account category.
- Select Indent / Outdent / Move Up / Move Down action for arrange the sub-category level.
- Enter G/L Account No. in G/L Accounts in Category for setup the account directly.
To Create new G/L Account
- Go to Chart of Accounts List than click [New] on the Action Bar.
- Fill up the basic G/L Account information as below:
- No
- Name
- Income/Balance
- Account Category
- Account Subcategory
- Debit/Credit
- Account Type
- Totalling - fill up if the account type is End Total.
- Direct Posting - unselect for sub-ledger account (eg AR, AP, Bank etc)
- Default Dimension (if any)
- Select action button Account/Dimensions if need to setup default dimension for the G/L Account
Anchor | ||||
---|---|---|---|---|
|
- Mapping for Balance Sheet Account
- Bank Account Posting Groups
- Customer Posting Group
- Vendor Posting Groups
- Inventory Posting Setup - (Inventory Posting Group + Location)
- Mapping for Income Statement Account
- General Posting Setup- (General Business Posting Groups + General Product Posting Groups)
- Mapping for Balance Sheet Account
Anchor | ||||
---|---|---|---|---|
|
- No. Series Code
- No. Series Line
- No. Series Relationships
- Default / Manual No.
- Sales & Receivable (Set Customer and Sales Document No. Series)
- Purchase & Payable (Set Vendor and Purchase Document No. Series)
- Inventory Setup (set Item and Inventory Document No. Series)
- Marketing Setup (setup Contact No. Series)
- Human Resources Setup (setup Employee No Series)
- Journal Batch – setup no. series for the journal.
Anchor | ||||
---|---|---|---|---|
|
- Create New Accounting Period
- Only 12 period, will not have 13 periods for audit adjustment.
- General Ledger Setup
- Allow Posting From & Allow Posting To
- User Setup
- Allow Posting From & Allow Posting To per user
- Create New Accounting Period
Anchor | ||||
---|---|---|---|---|
|
General Ledger Setup
Tab | Setup Information |
General |
|
Dimensions | Define the Global Dimension and other 6 shortcut dimension for the company.
|
...
- Accounting Periods
- Dimensions
- User Setup
- Posting Group and Posting Setup
Anchor | ||||
---|---|---|---|---|
|
- Discount Posting
Discount posting can be configured in Sales and Receivable set up with following options.
Case Example:
...
Number series configuration for sales documents
Anchor | ||||
---|---|---|---|---|
|
- Discount Posting
Same logic with Discount Posting setup in Sales & Receivable Setup.
...
Number series configuration for Purchase documents
Anchor | ||||
---|---|---|---|---|
|
- New configuration in Business Central
...
- Number series configuration for Inventory Documents
Anchor | ||||
---|---|---|---|---|
|
- FA Location
- FA Class
- FA Subclass
- Depreciation Book
- FA Journal Setups – Action button in Depreciation Book Card.
- FA Setup (Set FA No. Series)
Anchor | ||||
---|---|---|---|---|
|
- Interaction – set up the business relation code.
- Numbering – setup the number series for Contact Nos.
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
** Mandatory Field
- ### **{}No. (System Generates / Manual Input according to No. Series setup)
- Name
- Sell-to Address
- **{}Gen. Bus. Posting Group (determine Income Statement Accounts)
- **** Customer Posting Group (determine Balance Sheet Accounts)
- Currency (if blank = LCY)
- Payment Terms Code
- Shipment Method Code
- Default Dimensions
- System auto default Customer No. as Same Code Dimension
- Ship-to Address
- ### **{}No. (System Generates / Manual Input according to No. Series setup)
Anchor | ||||
---|---|---|---|---|
|
** Mandatory Field
- **{}No. (System Generates / Manual Input according to No. Series setup)
- Name
- Address
- **{}Gen. Bus. Posting Group (determine Income Statement Accounts)
- **** Vendor Posting Group (determine Balance Sheet Accounts)
- Currency (if blank = LCY)
- Payment Terms Code
- Location
- Shipment Method Code
Anchor | ||||
---|---|---|---|---|
|
Create Employee for record and reimburse employees' expenses in a similar way as of vendors.
Mandatory Field
...
Note: Employee transactions can be posted in the local currency only. Reimbursement payments to employee do not support discounts and payment tolerances.
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
** Mandatory Field
- **{}No. (System Generates / Manual Input according to No. Series setup)
Wiki Markup |
---|
If number series is separate for different type of item, user can click the \[…\]button next to No. field to select the appropriated no. series. |
- Description
- Description 2
- **{}Base Unit of Measure
- **{}Gen. Prod. Posting Group (determine Income Statement Accounts)
- **** Inventory Posting Group (determine Balance Sheet Accounts)
- **{}Type (Options: Inventory, Non-Inventory, Services)
Anchor | ||||
---|---|---|---|---|
|
The Inventory type (i.e. "Type" in item card) involves full tracking of inventory quantity and value. Therefore, all item transaction types, and item handling features are supported.
The Service and Non-Inventory types do not involve tracking of inventory quantity and value. Only selected item transaction types and features are supported.
Item Type | Sales | Purchasing | Job Consumption | Location Transfer | Physical Counting | Inventory Costing | Planning |
Inventory | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Non-Inventory | Yes | Yes | Yes | No | No | No | No |
Service | Yes | Yes | Yes | No | No | No | No |
Anchor | ||||
---|---|---|---|---|
|
Open the item card which intended to make a copy then select Function => Copy Item in action bar.
Anchor | ||||
---|---|---|---|---|
|
Setup template for fill up default value for different type of items.
Anchor | ||||
---|---|---|---|---|
|
** Mandatory Field
- **{}No. (Manual Input)
- Description
- Currency (if blank = LCY)
- **{}Bank Account Posting Group (determine Income Statement Accounts)
Anchor | ||||
---|---|---|---|---|
|
** Mandatory Field
- **{}No. (Manual Input)
- Description
- Depreciation Book Code
- **{}Posting Group
- Depreciation Method
- Depn. Starting Date
- No. of Depn. Years
Anchor | ||||
---|---|---|---|---|
|
Analysis View allow user to setup the analysis dimension for attach to Account Schedule or preview the report by Analysis View.
- Setup Analysis View – in Analysis View List, select New for add the Analysis View Card then enter the information's below:
- Code and Name.
- Account Source – select G/L Account.
- Account Filter – enter the G/L Account that you want to see in the report. Lave blank if show all G/L account.
- Dimension – enter the dimension that you want to see in the report. Max 4 dimension can be select in analysis view.
- Analysis by Dimensions – in Analysis View List, select Analysis by Dimensions.
- Select the criteria in the page then click Show Matrix to preview the Analysis View.
- Setup Analysis View – in Analysis View List, select New for add the Analysis View Card then enter the information's below:
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
Account Schedules allow the financial users to create their own financial reports & statements.
- Column Layout – Determine how the numbers will be displayed in column, for example.
- Multiple periods showing monthly columns.
- Columns showing the period to date previous year/month and variance to current.
- Row Layout – The row it planned to show on report.
- Column Layout – Determine how the numbers will be displayed in column, for example.
Anchor | ||||
---|---|---|---|---|
|
- Create or edit column layout.
- Select an account schedule and then select Process > Edit Column Layout Setup.
- In the Name field, select an existing column layout or create a new one.
- Sample for column layout.
- Compare amount with last month.
- For compare the amount for current month and last month, enter "-1M" in Compare Date Formula column
- For calculate the difference, enter the calculation in Formula column.
- Compare amount with last month.
...
For more information on formulas, please see the details by the link below:
https://docs.microsoft.com/en-us/dynamics365/business-central/bi-how-work-account-schedule
Anchor | ||||
---|---|---|---|---|
|
Create new account schedule.
Go to Account Schedule Page than Click [New [on the Action Bar
- Fill up the Name and Description for the new account schedule.
- Select the default column layout.
- (Optional) Assign Analysis View for filter account schedule by Dimensions if needs.
Note: assign analysis view to account schedule for use the dimensions that are assigned to the analysis view. Otherwise, only two global dimensions in an account schedule can be use.
Copy Account Schedule
Select account schedule that you want to make a copy then select Process > Copy Account Schedule in action bar.
Filter account schedule by using dimension.
Steps for setup dimension filter in row.
...
- Select an account schedule and then select Process > Edit Column Layout Setup.
- In the Name field, select an existing column layout or create a new one.
- Use the personalize function to add the column for Dimension.
- Select a line then enter the dimension value in the dimension column.
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
- Create New Batch and Assign No. Series / Select existing batch.
- Enter Entries
- Renumber Document No. => Actions/Functions
- Preview Posting => Actions/Posting
- Standard General Journal
Anchor | ||||
---|---|---|---|---|
|
- Cash Receipt Journal
- Create New Batch and Assign No. Series / Select existing batch.
- Enter Entries
- Applies-to Doc. No. *System auto fill-in Amount on entry line.
- Apply multiple entries – select Process =>Apply Entries…
- Register Customer Payment
- Go to customer page, select customer, and then select Process > Register Customer Payments.
- Set up for select batch and balance account.
Anchor | ||||
---|---|---|---|---|
|
- Payment Journal
- Create New Batch and Assign No. Series / Select existing batch.
- Enter Entries
- Applies-to Doc. No. *System auto fill-in Amount on entry line.
- Apply multiple entries – select Process =>Apply Entries…
- Pay Vendor
- Go to vendor page, select vendor, and then select Process > Pay Vendor.
- Select vendor ledger entries, and then select Process -> Create Payment.
Anchor | ||||
---|---|---|---|---|
|
Recurring Method
Balance
The balance of the account on the line is allocated among the accounts and dimensions specified for the line on the Allocation page.
For example, the allocation of an expense account across departments.Fixed
Use when the journal amount is the same each period. The amount in the journal line remains unchanged after posting.
For example, monthly fixed expenses such as rent.Variable
Use when the journal amount is different each period. The amount on the journal line is cleared to zero after posting.
For example, monthly variable expenses such as salaries and wages.- Recurring Frequency
...
Enter dimension for the entry if needs.
Anchor | ||||
---|---|---|---|---|
|
- Reverse the general ledger entry.
- Go to General Ledger Entries page then select the entry that you want to reverse.
- Select Reverse Transaction action.
- On the Reverse Transaction Entries page, select Reverse action.
- Reverse the general ledger entry.
...
- Create a sales credit memo for reverse.
- Open the posted sales invoice that you want to reverse then select Create Corrective Credit Memo action button.
- In the credit memo, edit the information if needs, then select Apply Entries action button.
- On the Apply Customer Entries page, select the line with he posted sales document that need to reverse then select Applies-To ID action button.
- Post the credit memo for reverse the invoice.
- Create a sales credit memo for reverse.
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
All double entries posted.
- Report – shows the related entries per register.
- Archive – preview the related entries on G/L Registers list
Anchor | ||||
---|---|---|---|---|
|
All double entries posted.
- G/L Dimension Overview
- Reverse G/L Entries
- Change Posting Description
- Show change history for the entries
Anchor | ||||
---|---|---|---|---|
|
Sub-ledger of all "Customer" Type Balance Sheet Entries.
- Accounts Receivable
- Received in Advance.
- Apply Entry
- Unapplied Entry
Anchor | ||||
---|---|---|---|---|
|
Sub-ledger of all "Vendor" Type Balance Sheet Entries.
- Accounts Payable
- Deposit Paid
Anchor | ||||
---|---|---|---|---|
|
Sub-ledger of all "Bank" Type Balance Sheet Entries.
- If use Bank Reconciliation Function in system. Have indicator for validated bank entries.
Anchor | ||||
---|---|---|---|---|
|
- Account Schedule – Balance Sheet
- Account Schedule – Income Statement
- Trial Balance
- Customer Statement
- Customer Detailed Aging
- Customer – Summary Aging
- Aged Accounts Receivable
- Aged Accounts Payable
- Fixed Assets Book Value 01
- Inventory Valuation
*Select Explore All to preview all Business Standard Report for each functional area.
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
- Calculate Depreciation.
- Post Recurring Journal.
- Check all journal batches.
- Bank Account Reconciliations
- Exchange Rate Update
- Adjust Exchange Rates
- Enter Ending Date for exchange rate adjustment.
- G/L entries for Currency Gain and Losses account to be generated.
Anchor | ||||
---|---|---|---|---|
|
- Check all Journals, Orders, Invoices section
...