Tracking restricted grants - Revision history

Rfs at 18:47, 31 January 2013

2013-01-31T18:47:43Z

Rfs at 18:43, 31 January 2013

2013-01-31T18:43:54Z

Rfs at 18:41, 31 January 2013

2013-01-31T18:41:42Z

Rfs: Created page with "When Free Geek receives a grant it will often have restrictions placed on it. For example, in 2008 we received a grant for $24,950 to purchase a truck with a lift gate. The gra…"

2013-01-31T18:25:10Z

Created page with "When Free Geek receives a grant it will often have restrictions placed on it. For example, in 2008 we received a grant for $24,950 to purchase a truck with a lift gate. The gra…"

New page

When Free Geek receives a grant it will often have restrictions placed on it. For example, in 2008 we received a grant for $24,950 to purchase a truck with a lift gate. The grant covered several associated expenses as well. Because the grant was in support of certain types of purchases and not others, we need to account for where the money went. This page describes how to do that in our books.

When a grant comes in, we need to maintain '''a file of all documents related to the grant'''. This can be useful in determining whether a transaction meets or does not meet the restrictions put in place by the grant.

The grant must be recorded in an income as of the date we know (a) the amount of the grant, and (b) that there is an agreement that we will get the grant. A typical income account that this might appear in is numbered something like 423X-ZZZ, where 423X indicates the natural account (Foundation/trust grants) and ZZZ indicates the program the grant is associated with. If a grant is recorded on the day we receive the check, the transaction will look something like this:

* 3/18/2008
** 1041 Cash:Petty Cash:Safe $24,950 ''Debit''
*** 4231-230 Non-government grants:Truck grant $24,950 ''Credit''
** G-001: grant for truck, lift gate, etc.

Each grant should be assigned a '''G-code'''. In the above example the G-code is G-001. This code will need to be recorded in the memo field of each transaction related to the grant (for reporting purposes).

[[Category: Accounting]]

@@ Line 16: / Line 16: @@
 Current grant codes (for bookkeeping purposes):
-* G-001: The truck grant (3/18/2008)
+* '''G-001''': The truck grant (3/18/2008)
-* G-002: The classroom grant (5/20/2011)
+* '''G-002''': The classroom grant (5/20/2011)
-At the end of the accounting period, when making adjusting entries, we need to print a report showing all the relevant transactions.  This can be done by searching for transactions containing the proper code in the memo.  We can use the details in this report to see how much of the grant has been properly spent.  We must then make an adjusting entry releasing the funds from a restricted income account to an unrestricted income account.  This will then appear on the balance sheet properly.  Here is an example from the end of the year 2008:
+At the end of the accounting period, when making adjusting entries, we need to print a report showing all the relevant transactions.  This can be done by searching for transactions containing the proper code in the memo and then generating an account report for the results.  It is often useful to cut and paste the results into a spreadsheet for analysis.  We can use the details in this report to see how much of the grant has been properly spent.  (By turning the initial grant amount into the spreadsheet to a negative number and then creating a running total it can be easy to see what is left over at the end of a period.)
 ----

@@ Line 7: / Line 7: @@
 ----
 ; 3/18/2008
-* 1041 Assets:Cash and equivalents:Petty cash & tills:Safe $24,950 ''Debit''
+: 1041 Assets:Cash and equivalents:Petty cash & tills:Safe $24,950 ''Debit''
-** 4231-230 Income:Non-government grants:Foundation/trust grants:Truck Grant $24,950 ''Credit''
+:* 4231-230 Income:Non-government grants:Foundation/trust grants:Truck Grant $24,950 ''Credit''
-* G-001: grant for truck, lift gate, etc.
+: G-001: grant for truck, lift gate, etc.
 ----
@@ Line 24: / Line 24: @@
 ----
 ; 12/31/2008
-* 6911-230 Income:Net assets released from restriction:Released recycling pick-up program (TR) $20,014.34 ''Debit''
+: 6911-230 Income:Net assets released from restriction:Released recycling pick-up program (TR) $20,014.34 ''Debit''
-** 6910-230 Income:Net assets released from restriction:Released recycling pick-up program (UR) $20,014.34 ''Credit''
+:* 6910-230 Income:Net assets released from restriction:Released recycling pick-up program (UR) $20,014.34 ''Credit''
-* G-001: partial satisfaction of grant
+: G-001: partial satisfaction of grant
 ----

@@ Line 5: / Line 5: @@
 The grant must be recorded in an income as of the date we know (a) the amount of the grant, and (b) that there is an agreement that we will get the grant.  A typical income account that this might appear in is numbered something like 423X-ZZZ, where 423X indicates the natural account (Foundation/trust grants) and ZZZ indicates the program the grant is associated with.  If a grant is recorded on the day we receive the check, the transaction will look something like this:
-* 3/18/2008
+----
-** 1041 Cash:Petty Cash:Safe $24,950 ''Debit''
+; 3/18/2008
-*** 4231-230 Non-government grants:Truck grant $24,950 ''Credit''
+* 1041 Assets:Cash and equivalents:Petty cash & tills:Safe $24,950 ''Debit''
-** G-001: grant for truck, lift gate, etc.
+** 4231-230 Income:Non-government grants:Foundation/trust grants:Truck Grant $24,950 ''Credit''
 Each grant should be assigned a '''G-code'''.  In the above example the G-code is G-001.  This code will need to be recorded in the memo field of each transaction related to the grant (for reporting purposes).
 [[Category: Accounting]]