Tips for updating QuickBooks
You can export a report, change certain format
QuickBooks will update and keep these changes
C4) Renamed report titles
(2) Font, Fill, and Number formatting
{in row & column headers only)
C3] Resized columns
oO Renamed column & row headers
rs} Inserted rows & columns
You must enter text or a formula in the row to preserve it.
6] New Excel formulas
The updated report must contain the row associated with )
@ inserted text
Make your new text always appear next to a particular row
the text as a formula (e.g. ="inserted text”)
QuickBooks will NOT - Font formatting inr
support these changes: - Inserted rows that ¢
- Moved data cells
reports in Excel
‘ting or add new formulas, and then update it with new Quickt
fe
oe
i
ow F a 3 oe
Profit & Loss
July through August 2012 e
your formula
1 by entering
KCSLCOEILH Ld dn al a ad all
>
yon-header cells* - Renamed date columns - Inserted colurnns in -
ire left empty - Deleted columns between QuickBooks
- Sorted columns row headers
—— a |
| formulas may not be
collapsed reports when
he same excel sheet
Virginians for Alternatives to the Death Penalty
Income Statement
Budget vs. Actual
November 2018 YTD with Revised Budget
Ordinary Income/Expense
Income
43300 - Direct Public Grants
43313 - Tides DP Mol
43313 - Tides DP Capacity Buil
43331 - Sisters of Bon Secours
43332 - Daughters of Wisdom
43340 - Nonprofit Group' Grants
43350 - Faith Community Grants
Total 43300 - Direct Public Grants
43400 - Direct Public Support
43410 - Individual Contributions
ization Fund
43411 - Online Donations
43412 - Network For Good
43410 - Other Contributions
Total 43410 - Individual Contributions
43420 - Major Donors
43430 - Board Member Donations
43451 - AmazonSmile
Total 43400 - Direct Public Support
46430 - Miscellaneous Revenue
49000 - Special Events Income
49010 - Events Contributions
49020 - Events Sales
Jan 2018 Feb 2018 Mar 2018 Apr 2018 May 2018
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 15,000.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
2,497.16 100.00 750.00 4,000.00 0.00
2,497.16 100.00 750.00 19,000.00 0.00
525.00 60.00 25.00 68.00 283.00
170.00 35.00 0.00 0.00 0.00
830.00 0.00 150.00 427.10 1,127.76
1,525.00 95.00 175.00 495.10 1,410.76
9,725.05 1,620.05 1,325.05 1,365.05 3,577.45
1,665.00 275.00 685.00 540.00 540.00
0.00 8.80 0.00 0.00 11.78
12,915.05 1,998.85 2,185.05 2,400.15 3939-99
0.00 0.00 0.00 0.00 150.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
Page 4 of 9
Virginians for Alternatives to the Death Penalty
Income Statement
Budget vs. Actual
November 2018 YTD with Revised Budget
Jan 2018 Feb 2018 Mar 2018 Apr 2018 May 2018
Total 49000 - Special Events Income 0.00 0.00 0.00 0.00 0.00
Total Income 15,412.21 2,098.85 2,935.05 21,400.15 5,689.99
Page 5 of 9
Virginians for Alternatives to the Death Penalty
Income Statement
Budget vs. Actual
November 2018 YTD with Revised Budget
Ordinary Income/Expense
Income
43300 - Direct Public Grants
43313 - Tides DP Mol
43313 - Tides DP Capacity Buil
43331 - Sisters of Bon Secours
43332 - Daughters of Wisdom
43340 - Nonprofit Group' Grants
43350 - Faith Community Grants
Total 43300 - Direct Public Grants
43400 - Direct Public Support
43410 - Individual Contributions
ization Fund
43411 - Online Donations
43412 - Network For Good
43410 - Other Contributions
Total 43410 - Individual Contributions
43420 - Major Donors
43430 - Board Member Donations
43451 - AmazonSmile
Total 43400 - Direct Public Support
46430 - Miscellaneous Revenue
49000 - Special Events Income
49010 - Events Contributions
49020 - Events Sales
Jun 2018 July 2018 Aug 2018 Sept 2018 Oct 2018
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 15,000.00
0.00 0.00 0.00 0.00 0.00
2,150.00 800.00 550.00 2,000.00 450.00
2,150.00 800.00 550.00 2,000.00 15,450.00
45.00 30.00 80.00 25.00 75.00
0.00 20.00 425.00 1,441.00 0.00
335.00 245.00 150.00 50.00 255.00
380.00 295.00 655.00 1,516.00 330.00
1,838.71 3,765.05 1,185.05 615.05 1,650.05
395.00 785.00 1,565.00 6,370.00 570.00
0.00 0.00 5.58 0.00 0.00
2,613.71 4,845.05 3,410.63 8,501.05 2,550.05
0.00 0.00 0.00 0.00 8.39
0.00 0.00 0.00 0.00 164.00
0.00 0.00 35.00 105.00 5.00
0.00 250.00 150.00 275.00 2,350.00
Page 6 of 9
Virginians for Alternatives to the Death Penalty
Income Statement
Budget vs. Actual
November 2018 YTD with Revised Budget
Jun 2018 July 2018 Aug 2018 Sept 2018 Oct 2018
Total 49000 - Special Events Income 0.00 250.00 185.00 380.00 2,519.00
Total Income 4,763.71 5,895.05 4,145.63 10,881.05 20,527.44
Page 7 of 9
Virginians for Alternatives to the Death Penalty
Income Statement
Budget vs. Actual
November 2018 YTD with Revised Budget
TOTAL
Nov 2018 Jan - Nov Budget % of Budget
Ordinary Income/Expense
Income
43300 - Direct Public Grants
43313 - Tides DP Mobilization Fund 0.00 0.00 0.00
43313 - Tides DP Capacity Buil 0.00 0.00 0.00
43331 - Sisters of Bon Secours 0.00 15,000.00 15,000.00 100.0%
43332 - Daughters of Wisdom 0.00 15,000.00 15,000.00 100.0%
43340 - Nonprofit Group' Grants 0.00 0.00 0.00
43350 - Faith Community Grants 500.00 13,797.16 15,000.00 92.0%
Total 43300 - Direct Public Grants 500.00 43,797.16 45,000.00 97.3%
43400 - Direct Public Support
43410 - Individual Contributions
43411 - Online Donations 75.00 1,291.00 3,300.00 39.1%
43412 - Network For Good 110.00 2,201.00 200.00 1100.5%
43410 - Other Contributions 422.10 3,991.96 4,000.00 99.8%
Total 43410 - Individual Contributions 607.10 7,483.96 9,000.00 83.2%
43420 - Major Donors 4,320.05 30,986.61 53,000.00 58.5%
43430 - Board Member Donations 1,470.00 14,860.00 16,500.00 90.1%
43451 - AmazonSmile 0.00 26.16 0.00
Total 43400 - Direct Public Support 6,397.15 53,356.73 78,500.00 68.0%
46430 - Miscellaneous Revenue 0.00 158.39 0.00
49000 - Special Events Income 0.00 164.00
49010 - Events Contributions 500.00 645.00 500.00 129.0%
49020 - Events Sales 0.00 3,025.00 2,500.00 121.0%
Page 8 of 9
Virginians for Alternatives to the Death Penalty
Income Statement
Budget vs. Actual
November 2018 YTD with Revised Budget
TOTAL
Nov 2018 Jan - Nov Budget % of Budget
Total 49000 - Special Events Income 500.00 3,834.00 3,000.00 127.8%
Total Income 7,397.15 101,146.28 126,500.00 80.0%
Page 9 of 9