BOOKKEEPING DATABASE for REPAIR SHOP
Budget: $30 – $250 USD
The MS ACCESS database will have the following functions:
A. TO RECORD EACH WORKING DAY:
1. Daily income made by each worker, include:
a. Credit card
b. Cash
c. Tip
d. Misc Income
2. Daily Discount Coupon received
B. SHOP EXPENSES:
1. Rent
2. Electricity
3. Water
4. Advertising
5. Repair
6. Parts
7. Supplies
8. Misc 1
9. Misc 2
10. Misc 3
C. REPORTS TO MAKE:
1. First Semi-monthly gross/net income made by each worker
2. Second Semi-monthly gross/net income made by each worker
3. Employee 1099 Yearly Report
4. Yearly shop gross /net income
NOTES:
1. MENU with each function needed
2. ALL tables, queries, and forms can be modified when needed
3. Will discuss in detail when work is assigned.
A. TO RECORD EACH WORKING DAY:
1. Daily income made by each worker, include:
a. Credit card
b. Cash
c. Tip
d. Misc Income
2. Daily Discount Coupon received
B. SHOP EXPENSES:
1. Rent
2. Electricity
3. Water
4. Advertising
5. Repair
6. Parts
7. Supplies
8. Misc 1
9. Misc 2
10. Misc 3
C. REPORTS TO MAKE:
1. First Semi-monthly gross/net income made by each worker
2. Second Semi-monthly gross/net income made by each worker
3. Employee 1099 Yearly Report
4. Yearly shop gross /net income
NOTES:
1. MENU with each function needed
2. ALL tables, queries, and forms can be modified when needed
3. Will discuss in detail when work is assigned.