Annual Chart of Accounts Instructions

Each BCHW Chapter is required to complete and transfer a Chart of Accounts spreadsheet (COA) to the BCHW treasurer on or before January 20th of each year.  It is the Chapter's responibility to meet this requirement without exception.

The COA is an Excel Spreadsheet consisting of three separate tabs.  One tab is for the Chapter Financials,  one for the Non Cash Contribution Log and one for the IRS Worksheet.   The COA spreadsheet is relatively self explainitary with notes of what is expected in each cell or line.  Some notes follow:

1.   It is best to open the blank COA and do a File - Save As, renaming the the file with the chapter name included in the file name.  For example the blank file "Chapter coa 2019.xlsx" could be renamed to "Lewis County Chapter coa 2019.xlsx".  

2.   YELLOW colored cells is where CHAPTERS may enter information.

3.   Cells that are not Yellow should not be changed or edited in any way.

4.   Where yellow cells call for an amount that does not aply to your chapter, leave the cell blank.  DO NOT enter zeros (0's).

5.   The Chapter's accounting year can be anything as long as it is a full year.  IE, it does not have to be Jan 1 to Dec 31.  

6.   After all the information is added on the Chapter Financials tab the Ending Balance amounts in the Gray cells D69 and D70 must be the same.   If they are not, there is an error in the entries above and it must be corrected. 

7.   Don't forget to fill on the Non Cash Contribution Log tab if it applys.  

8.   The information requested on the IRS Worksheet tab is required from all chapters.

9.   If you have any questions or need help,  contact the BCHW treasurer at:  treasurer@bchw.org

10.   When complete email the COA file to the BCHW treasurer at:  treasurer@bchw.org

Back to the BCHW 501(c)(3) Guidelines page