Begin-Total and End-Total

(0) Share

Report

Posted on by OzanS

Hello,

I would like to understand the reason of using an End-Total if we can use the formula to sum in the Begin-Total area. Normally, we are leaving "Totaling" area blank for "Begin-Total" and using the formula in the "End-Total" line. This means a lot of unnecessary lines in CoA. Can't we skip "End-Total" by using the formula in the "Begin-Total"? (or the opposite)

What is the advantage of repeating them at the beginning and at the end of each account group, and what will I loose if I don't use a line for End-Total (maybe its not even possible)

Thanks in advance

Best Regards

No.	Name	Search Name	Account Type	Totaling
10000	INCOME STATEMENT	INCOME STATEMENT	Heading
10001	INCOME	INCOME	Begin-Total
10100	Income, Services	INCOME, SERVICES	Posting
10200	Income, Product Sales	INCOME, PRODUCT SALES	Posting
10250	Job Sales	JOB SALES	Posting
10300	Sales Discounts	SALES DISCOUNTS	Posting
10400	Sales Returns & Allowances	SALES RETURNS & ALLOWANCES	Posting
10450	Job Sales Applied	JOB SALES APPLIED	Posting
10500	Interest Income	INTEREST INCOME	Posting
10990	TOTAL INCOME	TOTAL INCOME	End-Total	10001..10990

Categories:

Administration and Setup

All responses (3)

Answers (0)

SLorrain 15 on at

Like (0)

Report

RE: Begin-Total and End-Total

I agree with Akash's response that the Beginning - End totalling is for grouping your accounts into proper financial sections. Without these and the totals your data would be messy to look at on the chart of accounts.
Suggested answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: Begin-Total and End-Total

Hello,

Adding to Akash's reply... The Begin-Total and End-Total allow for the Chart of Accounts to create section sub-totals. You can see this when creating the Chart of Accounts or how you pull in accounts into an Account Schedule. Now, certainly you do not have to have these but then you will have to export your Chart of Accounts to Excel to create Sub-Totals and Totals or you can just have your Accounts Schedules reflect the Sub-Totals and Totals. This portion can be done easily with Jet Reports or Power BI.

Hope this help.

Thanks,

Steve
Suggested answer

Akash Shukla 335 on at

Like (0)

Report

RE: Begin-Total and End-Total

Hello OzanS,

Basically we are using Begin Total and End Total for grouping purpose. In COA if you explore then you find that End Total is sum up of all posting G/L. Begin Total is nothing but it's help to sum G/L as per heading wise, Balance sheet account wise.

Hope this will helpful for you.

Please verify this if you find this helpful.

Thanks.