Closing out the month

These are checklists of things that need to be done before the month is closed out for bookkeeping. By completing all the items on this list, we ensure a more accurate picture of actual income and expenditures -- useful when setting the budget. Sometimes transaction details that occur during a given month aren't known until a few weeks later, but in general transactions should be recorded as close as possible to the date of the transaction. When the amount is not expected to be known for a while, it may be necessary to enter a reasonable estimate in a timely manner, rather than wait for the details to settle.

Basics of catching up on the books

Target: Done by the 12th day of the month.

1. record all checks from checkbook in books
2. check the "Orphan" account for mistakes (this should actually be checked every time you use gnucash)
   • Imbalance-USD
   • Orphan-USD
3. pay bills, making sure to record not only the payment (which is to an a/p) but the expense as well.
   • record bills that have been paid automatically (If there have been any staffing changes involving credit card holders, make sure the online payments are still valid.)

   PGE

   NW Natural

   Rackspace (cc)

   Waste Connections

   Comcast

   Portland Water (EFT - main checking) (quarterly - 3 6 9 12 )

   • Note: There are 4 separate water accounts and changing the credit card requires changing each of those accounts separately.

   Kaiser

   Paychex

   ...

   • Bills that need to be manually paid online

   ...

   • write and mail checks for bills that need manual payment

   Integra

   Central Electronic Alarm (quarterly)

   ...

   • (get authorization from appropriate committee if bill is at all questionable)
4. pay rent
5. record payroll transactions
   • net pay, etc.
   • tax withholding
   • oddball deductions, such as advance paybacks, etc.
   • divide the expenses between months for pay periods that straddle two months
     • divide by the number of work days on each side (this is not exact but is close and good enough for our purposes)
     • remember that certain employees get holiday pay so if the pp includes a holiday that category will need to be split differently.
     • divide payroll tax expense as well. If the staff categories have different ratios of work days, then create a new ratio from the total payroll expense and use that.
6. retirement
   • Get and record reports from Mark
7. record receipts
   • credit card
   • reimbursements (from cash box)
8. record daily income reports
   • credit and debit card transactions for front desk and thrift store
   • "till total" amounts for front desk and thrift store
   • daily transfers for front desk and thrift store (from end of shift forms)
   • miscellaneous transactions (reimbursements, IOUs, money receipts)
   • corrections (overages and short tills)
   • Invoiced donations
9. record deposits
10. record online account transactions
    • eBay (download spreadsheet)
    • online paypal donations (download spreadsheet)
      • Verify whether any are for invoiced donations or sales
      • Verify that all donations are in the database.
    • Network for Good
      • Log in to website https://www.networkforgood.org/NPO/MyAccount/Login.aspx
    • WWeek Give Guide!
    • initiate a transfer to appropriate bank accounts and have michael finish it by transferring money into savings
11. check A/R accounts
    • recycling vendors (i.e. Bear, Greenwall)
      • NCER
      • Metro Metals
      • Hallmark
      • Schnitzer
      • Wireless Alliance
12. check A/P accounts
    • recycling vendors
      • Total Reclaim
13. reconcile bank accounts
    • ebay transfer
    • donations transfer
    • savings (operating reserve)
    • main checking
    • restricted
    • Capital Pacific
14. reconcile cash box
15. Invoiced donations
    • Make sure all donations in the database are in the books.
    • Make sure insurances and depreciation are entered as monthly values.

Adjusting Entries

1. Reversing income entries
   • In the event that we estimated an income amount in a previous month (for example a recycling shipment with an estimated number) it is possible that the amount has been settled on. We will need to enter a transaction dated the first of the new month to undo the estimate and with it the actual amount. The difference should be (relatively) minor.
2. Estimating expense entries
   • In the event that an expense amount is forthcoming that will affect the previous month (for example a payroll expense for a two week period that will occur in a few days from the start of the new month) the amount affecting the earlier month should be estimated and entered. When the amounts are known, we will need to enter a transaction to undo the estimate and with it the actual amount. The difference should be (relatively) minor.

End of the Month Review Process

Target: Done by the 15th day of the month.

1. Check all prepaid expenses (Asset account, Other Assets)
   • Enter the monthly amount to expense
   • (typically insurance paid ahead of time). Expenses should be 1/12 of the annual amount.
2. Check all accumulated depreciation (Contra-asset account)
   • Enter the monthly amount to expense
   • (typically fixed operating assets paid ahead of time). Expenses should be based on the expected life of the asset.

Review Miscellaneous accounts for transactions that should be re-classified.

Also, search for transactions over $1,000 and determine if they should have been capitalized.

Check online accounts (PayPal, etc.) and initiate transfers to bank accounts. Make a note to follow up and sweep receiving bank account into main bank account in a few days.

Check all bank account balances and initiate transfers to maintain proper balances.

Reports

Target: Done by the 20th day of the month.

• (A) Balance sheet / Statement of Financial Position for end of previous month (before the month just completed)
• (B) Income statement / Statement of Activities for the new month
• (C) Balance sheet / Statement of Financial Position for end of the new month (the month just completed)

(C) from one month should always match (A) from the subsequent month.