ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   church expenses, income work sheets (https://www.excelbanter.com/excel-discussion-misc-queries/36037-church-expenses-income-work-sheets.html)

First Baptist Church

church expenses, income work sheets
 
Our Baptist Church needs:
A work sheet or data base that we can enter each expense by budget account number.
Same for income according to budget account number.




FASTWRX

What you can do is simply add a column into a general ledger-style excel
worksheet and use it for the Budget Account Number. (e.g. . . .
BAN Entry Debit Credit
123 God 10.00
134 Maint 20.00
254 Donat 100.00

This way, you can have a general ledger setup (if that is what you want),
but you can still sort by your Budget Account Number and do subtotals and
such. From history, I recommend separating income and expense numbers.
(100's for income / 200's for expenses)

"First Baptist Church" wrote:

Our Baptist Church needs:
A work sheet or data base that we can enter each expense by budget account number.
Same for income according to budget account number.





All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com