Chart of Accounts and the Use of Date Filter in Business Central #d365bc #coa #date #filter #generalledger #financialstatements #balancesheetitems #p/lAccount

Freelancer Madhavi

💁Agenda of the Video▶️: To Show, How-To assign "Date Filter" in Chart of Accounts (COA) List Page in Business Central. ✅Hint1️⃣: Try to View "Chart of Accounts" List Page as a whole report, like a Trial Balance (TB) Report. ✅Hint2️⃣: Financial Statement = Profit & Loss Account, AND Balance Sheet.

Transcript

00:00hello friends welcome to my channel i am freelancer madhvi and today we are going to discuss

00:11the chart of account date filter and how you can see trial balance

00:20many people do that when you check data from financials or general ledger

00:29they use trial balance but if you have a particular group or subgroup

00:37you can check the data from financials or income statements

00:41and check the data from the gs

00:45then you can check the chart of account and you can put date filter

00:49and if you want to put the statement filter

00:51then you can put the statement filter

00:53so i will show you how to do it

00:55now if you think we want to put the statement filter

00:58if you click on the filter filter or you can click on the filter box

01:05if you want to choose income statement or balance sheet

01:09then you can choose income statement

01:11then you can choose net change column

01:13that you can choose

01:15and if you want to choose balance sheet

01:17then you can choose balance sheet

01:19as on date

01:21balance at date column

01:23okay

01:25now we will check balance at date

01:27we will check balance sheet

01:29we will put balance sheet

01:31but now i will need date filter

01:33that i will put date wise

01:35now i will put balance at date

01:37so as on date

01:39as on date

01:41we will make financial statement

01:43we will make financial statement

01:45like balance sheet

01:47so as on date

01:49at the period end

01:51you will show closing values

01:53okay

01:55and net change

01:57income statement

01:59for the period

02:01okay

02:03what is the balance

02:05what is the balance

02:07what is the balance

02:09you can do in the system

02:10if there is future entries

02:11if there is future entries

02:13then you can include the future entries

02:15so now we will use balance at date

02:17because we are looking at balance sheet

02:19so now i will put date filter

02:21check the width

02:22which is the fault

02:23here in the field

02:24here again

02:25a filter button

02:27i will find the date and then

02:28here

02:29let me assume

02:30you have the 1st of the video

02:31that you have the data

02:32at the 31st of the month

02:34and you will see the date

02:36which is the date

02:37which is the date

02:38and you can choose

02:39as on date

02:40you have to understand

02:41what is the date

02:42and you have to be aligned

02:43here

02:44let us click balance at date

02:45choose

02:46the date

02:47then

02:47the date

02:48which is the balance sheet

02:49which is the balance sheet

02:50so you can write a filter on the balance sheet statement

02:54then you can also open it in excel

03:00and if you want to look at the balance sheet

03:05then you can also write a filter on the balance sheet

03:11and if you want to bring it in excel

03:14then you will find values

03:17and if you want to add income statement to the net change with the column here, you will need to add a filter to this

03:25and you will need to change the data to the income balance, and you will need to click on the balance sheet

03:33so this way, you will need to change the column to the net change and balance sheet to the balance sheet

03:41and here, you will need to change the statement in short form

03:47so this way, you can see a report directly from the chat app account

03:53which is connected to any statement, its group and subgroups and ledger and subledger

03:59Thank you for watching!

Category

Transcript

Recommended