# How can i calcultate average collectable balance? I am

Customer Question
how can i calcultate average...
how can i calcultate average collectable balance?
JA: The Accountant will know how to help. Please tell me more, so we can help you best.
Customer: I am looking at my bank statement and my bank has a section saying average collected balance and i would like to know how did they come about that number? is there a calculator that can help me figure it out?
JA: Is there anything else the Accountant should be aware of?
Customer: just understand if i had more money in there how can i calculate apparently this is important to the banks i am trying to get loan from. ?
JA: What confuses you?
Customer: well is my account says previous bal 8,186.99
Submitted: 1 year ago.Category: Canada Tax
Show More
Show Less
Customer reply replied 1 year ago
in the month of February my ending balance was 52,163.31 how can i come up with my average collected balance for my business account. Just the formula. As in another business account i have ending balance 02/29/16 93.31 and the statement for this account says Average Collected Balance is \$1870.83 I am puzzled. Would like to understand how to come up with that number for my \$52,163.31 ending balance same date the formula is my goal.
Customer reply replied 1 year ago
Posted by JustAnswer at customer's request) Hello. I would like to request the following Expert Service(s) from you: Live Phone Call. Let me know if you need more information, or send me the service offer(s) so we can proceed.
Customer reply replied 1 year ago
Ok no one has gotten back tome with my answer.
8/30/2016
Canadian Tax Expert: ABC Accounting Group, Certified Public Accountant (CPA) replied 1 year ago
ABC Accounting Group, Certified Public Accountant (CPA)
Satisfied Customers: 718
Verified

Hi. It is the average of collected funds (less any uncleared or uncollected deposits) in a bank account over a specified period, usually one month. The average collected balance is calculated by adding the daily collected balance and dividing by the number of days in the period

Canadian Tax Expert: ABC Accounting Group, Certified Public Accountant (CPA) replied 1 year ago

Computation - add the account balance at the end of each day of the month, and then divide by the number of days.

The average balance can also be calculated - is the begining and ending balance divided by 2.

Hope this helps.

Customer reply replied 1 year ago
This is Google response I want a formula. This is a rip off.
Canadian Tax Expert: ABC Accounting Group, Certified Public Accountant (CPA) replied 1 year ago

I am opting out. Thank you for your patience.

Canadian Tax Expert: Rick Martin, Certified Public Accountant (CPA) replied 1 year ago
Rick Martin, Certified Public Accountant (CPA)
Satisfied Customers: 93
Experience: CPA
Verified

Hi please send me a copy of the page with all the numbers and I will give you the formula.

Canadian Tax Expert: bkb1956, Tax Preparer replied 1 year ago
bkb1956, Tax Preparer
Satisfied Customers: 4,466
Experience: Tax preparer with 20+ years of experience
Verified

Different expert here - my name is ***** ***** please allow me to provide you with additional information you will find helpful.

Knowing a formula is not enough. You need to also know your bank’s policies for treating different funds as collected, its policies for treating funds in the average daily basis because of “holds,”, as well as the laws around what must be included in the collected balance.

The Average Collected Balance is used to determine the amount of interest to be paid on a monthly balance, since UNCOLLECTED funds (money coming into the account—sometimes even posted, but not yet physically received by the bank—DO NOT EARN INTEREST.

As an example, for business accounts, the Average Collected Balance is calculated by adding the COLLECTED balance in the account) (this is something you may or may not know) for each day of the period (monthly or other applicable period) and dividing that figure by the total number of days in that period.

Please be aware of the fact that the Average Collected Balance for the period may be a negative number if the bank permits you to overdraw the Collected Balance on any day(s).

For business Accounts that are not subject to Earnings Credit, the Average Collected Balance may be calculated based on the number of days the Account was open during the relevant period.

You may not have all of the data available to make the proper calculation.

When you notice a difference, this tells you that there are funds that showed up in the average daily balance that were not considered as COLLECTED, or the funds have not yet posted. For example, a wire transfer that is not yet posted because it came in after 3:00 pm, but it is considered as collected. This is defined a little differently by each bank and subject to their specific cutoff times.

Please let me know if I can assist you further.

Thank you and best regards,

Barb

bkb1956, Tax Preparer
Satisfied Customers: 4,466
4,466 Satisfied Customers
Experience: Tax preparer with 20+ years of experience

bkb1956 is online now

A new question is answered every 9 seconds

• Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
• Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

## What Customers are Saying:

I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response...

T.G.WMatteson, IL

I WON!!! I just wanted you to know that your original answer gave me the courage and confidence to go into yesterday's audit ready to fight.

BonnieChesnee, SC

Great service. Answered my complex tax question in detail and provided a lot of additional useful information for my specific situation.

JohnMinneapolis, MN

Excellent information, very quick reply. The experts really take the time to address your questions, it is well worth the fee, for the peace of mind they can provide you with.

OrvilleHesperia, California

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

< Previous | Next >

## Meet the Experts:

Arthur Rubin

Tax Preparer

34 satisfied customers

Tax preparer with 23 years experience, including US/Canada tax returns.

Legal Ease

Lawyer

269 satisfied customers

Lawyer

Wallstreet Esq.

Tax Attorney

586 satisfied customers

10 years experience

Mark D

Enrolled Agent

1,312 satisfied customers

MBA, EA, Specializing in Business and Individual Tax Returns and Issues

Richard

Tax Attorney

4,362 satisfied customers

29 years of experience as a tax, real estate, and business attorney.

Robin D.

14,119 satisfied customers

15years with H & R Block. Divisional leader, Instructor

Megan C

Certified Public Accountant (CPA)

8,652 satisfied customers

Licensed CPA, CFE, CMA, CGMA who teaches accounting courses at Master's Level

< Previous | Next >

If a company that closed over a decade ago owed sales taxes
If a company that closed over a decade ago owed sales taxes I know that the directors may still be personally liable. But I believe that there is a time limit of two years before a director's liabilit… read more
bkb1956
Tax Preparer
4,466 satisfied customers
I overpaid property taxes in 2015, the same year I sold the
I overpaid property taxes in 2015, the same year I sold the property. The tax office did not produce an accurate statement at closing so the lawyer could not collect the overpayment at time of sale. O… read more
Master's Degree
180 satisfied customers
In November of 2016 my girlfriend moved in together. In
In November of 2016 my girlfriend moved in together. In November of 2017 we became Common-law and filed notice to the CRA.As a result the CRA sent us notice that we are no longer eligible for certain … read more
Robin D.
14,119 satisfied customers
My name is ******* ******* my social security number is
My name is ******* ******* my social security number is ********* I have been trying to call Canada Revenue Agency but they say call later as we are over loaded . I also have been trying to figure out… read more
bkb1956
Tax Preparer
4,466 satisfied customers
I'm new to Canada and I don't know how to fill my tax
I'm new to Canada and I don't know how to fill my tax return. The tax section on canada.ca is too generic and doesn't help. Where do I get started?… read more
bkb1956
Tax Preparer
4,466 satisfied customers
I own 50% of a corporation that owns a vehicle. I want to
I own 50% of a corporation that owns a vehicle. I want to transfer the vehicle from the corporation to myself the shareholder. I understand I have to pay RST at the market value of the vehicle, but I … read more
Patrick Mullis
Masters
18 satisfied customers
I put down 'Personal' as my reason for moving to Canada when
Hello, I put down 'Personal' as my reason for moving to Canada when I arrived last week (departing in 5 months), and I'm curious to know if joining an 4-month acting program by the Victoria Academy of… read more
Legal Ease
Lawyer
Doctoral Degree
269 satisfied customers
Not sure if I am in the right section, a lawyer told me to
Not sure if I am in the right section, a lawyer told me to ask a tax expert. I want to know if I buy items from joom.com or wish.com for resale here in Canada by mail, do I have to fill a form to impo… read more
Master's Degree
180 satisfied customers
Canada real estate law question about resident capital gains vs non resident capital gains taxes.… read more
Legal Ease
Lawyer
Doctoral Degree
269 satisfied customers
To:, financial professional. Re Society Act in BC. Can a
To: ***** ***** professional. Re Society Act in BC. Can a member secure the membership of a society. I was told the list was confidential. As a member I feel (and I am sure I am right) that other memb… read more
bkb1956
Tax Preparer
4,466 satisfied customers
I am a Canad***** *****ving in Canada but worked at the University of California before retirement in 2001. In 2016, I made a disbursement from a 403B, a tax-deferred savings plan. The account is mana… read more
Robin D.
14,119 satisfied customers
Is there away to find what percent property taxes increased
Is there away to find what percent property taxes increased each year in Ontario from 1986 thru 1997 for a elderly person. I'm trying to figure out what taxes my 97 year old mother in law paid for tho… read more
Legal Ease
Lawyer
Doctoral Degree
269 satisfied customers
I am a Canadian permanent resident and a British citizen. I
Hi, I am a Canadian permanent resident and a British citizen. I have lived and worked in Canada for 9 years. I recently inherited GBP in the UK that was taxed in the UK according to UK inheritance tax… read more
Legal Ease
Lawyer
Doctoral Degree
269 satisfied customers
Is there a way to stop the CRA from garnishing wages?
is there a way to stop the CRA from garnishing wages? … read more
bkb1956
Tax Preparer
4,466 satisfied customers
My mom died in March whom owned all the shares. in May all
my mom died in March whom owned all the shares. in May all the shares were transferred into my name the fmv of the realestate was 1.7 million and i am informed that i shouldsell the corporate assets w… read more
Amanda Russell
Accounting Tax & Profit Strategist
Master\u0027s Degree
9 satisfied customers
I am a Canadian resident with an accounting question. Can
bkb1956
Tax Preparer
4,466 satisfied customers
2015 my husband had to cash in a rrsp for approx.\$13000.00
2015 my husband had to cash in a rrsp for approx.\$13000.00 and of course around \$2600.00 was taken for tax but when I did his 2016 he owes \$2400.00 but as soon as I enter this RRSP as income it adds a… read more
abci168
Principal
27 satisfied customers
I am the sole owner of a canadian limited company, I would
I am the sole owner of a canad***** *****mited company, I would like to take money out of my limited company for a down payment on a house I am buying, my previous answer says this money if not paid b… read more