Money Monitoring

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 455

BUDGETING

Time Date Income 50% Consumables


No. Budget Deduction
### 01:06:17 PM 12/30/1899 ₱368.00 184.00 224.00
### 01:06:17 PM 8/29/2023 ₱80.00 40.00 21.00
### 01:06:17 PM 8/29/2023 ₱80.00 40.00 115.50
### 01:06:17 PM 8/29/2023 ₱78.00 39.00 60.00
### 01:06:17 PM 8/29/2023 ₱100.00 50.00 537.00
### 01:06:17 PM 8/29/2023 ₱440.00 220.00 20.00
### 01:06:17 PM 8/29/2023 ₱1,056.00 528.00 90.00
### 01:06:17 PM 8/29/2023 ₱40.80 20.40 100.00
### 01:06:17 PM 8/29/2023 ₱100.00 50.00 3.90
### 07:33:00 PM 9/6/2023 ₱5,000.00 2500.00 1500.00
### 12:00:00 AM 12/30/1899 ₱2,000.00 1000.00 2000.00
### 11:27:43 AM 5/4/2024 ₱5,000.00 2500.00
BUDGETING
30% Investments 10% Enjoyment 10% Savings
Budget Deduction Budget Deduction Budget Deduction
110.40 216.30 36.80 44.80 36.80 39.10
24.00 113.00 8.00 29.10 8.00 50.00
24.00 30.00 8.00 150.00 8.00 100.00
23.40 103.00 7.80 10.00 7.80 45.00
30.00 15.00 10.00 0.38 10.00 296.75
132.00 40.00 44.00 296.75 44.00
316.80 25.00 105.60 105.60
12.24 47.72 4.08 4.08
30.00 45.00 10.00 10.00
1500.00 50.00 500.00 500.00
600.00 610.50 200.00 200.00
1500.00 500.00 500.00
CONSUMABLES
TOTAL BUDGET TOTAL DEDUCTION
₱7,171.40 ₱4,671.40 ₱2,500.00
INVESTMENTS
TOTAL BUDGET TOTAL DEDUCTION
₱4,302.84 ₱1,295.52 ₱3,007.32
ENJOYMENT
TOTAL BUDGET TOTAL DEDUCTION
₱1,434.28 ₱531.03 ₱903.25
SAVINGS
TOTAL BUDGET TOTAL DEDUCTION
₱1,434.28 ₱530.85 ₱903.43
TOTAL MONEY
₱7,314.00
TOTAL INCOME
₱14,342.80
Cridets Return
Time Name Amount Date Status
11:27 AM Venyale ₱200.00 8/14/2023 PD
11:27 AM Mike ₱200.00 8/14/2023 PD
11:27 AM Jeremy ₱125.00 8/16/2023 PD
11:27 AM Zeta ₱80.00 8/16/2023 PD
11:27 AM Moana ₱50.00 8/16/2023 PD
11:27 AM Jeremy ₱375.00 8/17/2023 PD
11:27 AM Moana ₱6.00 8/17/2023 PD
11:27 AM Jeremy ₱100.00 8/18/2023 PD
11:27 AM Jeremy ₱18.00 8/18/2023 PD
11:27 AM Jeremy ₱400.00 8/23/2023 PD
11:27 AM Zeta ₱210.00 8/25/2023 PD
11:35 AM Zeta ₱30.00 8/31/2023 PD
9:34 PM Jeremy ₱30.00 8/31/2023 PD
9:34 PM Cindy ₱15.00 8/31/2023 PD
8:40 PM Jeremy ₱25.00 9/1/2023 PD
9:44 AM Jeremy ₱30.00 9/5/2023
Return Money Add
Date Time Date Name Amount
8/17/2023 11:39 AM 8/19/2023 Jeremy ₱32.00
8/17/2023 11:40 AM 8/21/2023 Jeremy ₱80.00
8/17/2023 11:40 AM 8/22/2023 Jeremy ₱93.00
8/18/2023 11:40 AM 8/23/2023 Jeremy ₱100.00
8/25/2023 11:40 AM 8/24/2023 Jeremy ₱40.00
8/17/2023 11:40 AM 8/25/2023 Jeremy ₱1,000.00
8/25/2023 11:40 AM 8/27/2023 Jeremy ₱100.00
8/19/2023 7:35 PM 9/6/2023 Jeremy ₱5,000.00
8/19/2023
8/24/2023
8/31/2023
9/3/2023
9/3/2023
9/1/2023
9/3/2023
Net Credits
₱1,894.00
Net Money Input
₱6,445.00
REGESTER STOCK OUT
No. Load Description Retail Price Date Load Description
### 5.00 ₱10.00 8/29/2023 10.00
### 10.00 ₱15.00 8/31/2023 10.00
### 15.00 ₱20.00 8/31/2023 10.00
### 20.00 ₱25.00 9/15/2023 10.00
### 25.00 ₱30.00 9/15/2023 10.00
### 30.00 ₱35.00 9/15/2023 20.00
### 35.00 ₱40.00 9/15/2023 20.00
40.00 ₱45.00
50.00 ₱55.00
60.00 ₱65.00
70.00 ₱75.00
80.00 ₱85.00
90.00 ₱95.00
100.00 ₱105.00
STOCK OUT LOAD BALANCE UPDATE
LBD RP Profit Date LR Balance
10.00 ₱15.00 ₱5.00 8/28/2023 103.00 113.00
10.00 ₱15.00 ₱5.00 9/1/2023 10.00 GROSS TALLY
10.00 ₱15.00 ₱5.00 GPu
10.00 ₱15.00 ₱5.00 113.00
10.00 ₱15.00 ₱5.00 TOTAL
20.00 ₱25.00 ₱5.00 Puhunan
20.00 ₱25.00 ₱5.00 90.00

Date
BALANCE UPDATE
LD EB
90.00 23.00
GROSS TALLY
GS GPr
₱125.00 ₱35.00
TOTAL
Delensya Total
₱35.00 ₱125.00
EXPENCES
Expences Amount Estimated Cash IN amount
₱125.00
Door matt Bussiness
Date Materials Purchase Size
12/30/1899 Ziplock seal transparent bag 28 x 38 cm
8/27/2023 Door matt (Assorted design) 45 x 60 cm
8/31/2023 Printed Label 3 x 6 cm
DOOR M
Date Materials Qty
8/27/2023 Ziplock seal transparent bag 1
9/1/2023 Door matt (Assorted design) 4
9/1/2023 Printed Label 1
REGISTER
Date Product name Cost price
9/2/2023 1 Pack Door matt (Round type) ₱172.66
STOCK IN
Date Product name Qty
### 9/4/2023 1 Pack Door matt (Round type) 3.00
Door matt Bussiness
Qty Unit Price/pcs Amount TOTAL
10.00 PCS ₱10.30 ₱103.00 ₱543.00
12.00 PCS ₱35.00 ₱420.00
3.00 PCS ₱6.67 ₱20.00
DOOR MATT PRICE PER PACK
Size Unit Price/pcs Cost price Interest
28 x 38 cm PCS ₱10.30 ₱10.30 ₱1.03
45 x 60 cm PCS ₱35.00 ₱140.00 ₱14.00
3 x 6 cm PCS ₱6.67 ₱6.67 ₱0.67
REGISTER
Retail price IS Stock IN Stock OUT Ending Stock
₱180.00 0.00 3.00 0.00 3.00
STOCK OUT
Cost Price Total Date Product name Qty
₱172.66 ₱517.99
Retail price Price / pack
₱11.33 ₱172.66
₱154.00
₱7.33
TOTAL
NET COST NET SALES NET PROFIT GROSS PROFIT
₱517.99 ₱0.00 -₱517.99 -₱1,553.97
STOCK OUT
Cost price Retail price Profit Total
COSTUMERS INPUT
Date Print type Pages Copies Cost price
### 9/7/2023 A4 size 75.00 5.00 ₱2.00
### 9/7/2023 A4 size ₱2.00
REGISTER
Retail price Total Print type Cost price Retail price
₱3.00 ₱1,125.00 A4 size ₱2.00 ₱3.00
₱3.00 ₱0.00 Short ₱2.00 ₱3.00
Long ₱3.00 ₱4.00
Time Date of Purchase
#NAME? 09:19:43 PM 8/27/2023
#NAME? 09:19:43 PM 8/27/2023
#NAME? 01:59:04 PM 8/29/2023
#NAME? 04:08:29 PM 8/29/2023
#NAME? 07:35:02 PM 8/29/2023
#NAME? 11:49:22 AM 9/2/2023
#NAME? 06:52:59 PM 9/2/2023
#NAME? 10:22:14 PM 9/3/2023
PRODUCT PURCHASE
Description
Original Canon Power Supply for MP237/IP2770/MP258/MP397/MX377
1 Set Canon CISS W/ 4 Colors UV Dye Ink (C/M/Y/BK)
Vention Usb 2.0 Printer Cable For (hp/canon/epson) – 1m
Ziplock Seal Transparent Storage Bag Waterproof Travel Packing for Clothes
Door matt round type
Textstyle Frosted Matte Black/Black Zip Bag Seal for Clothes & Apparel
Printed Label
Door matt round type
T PURCHASE
MS SF SDS OT STATUS
₱250.00 ₱58.00 ₱58.00 ₱250.00 PD
₱185.00 ₱120.00 ₱60.00 ₱245.00 PD
₱109.00 ₱60.00 ₱17.00 ₱152.00 PD
₱110.00 58.00 ₱55.00 ₱113.00 PD
₱210.00 ₱0.00 ₱0.00 ₱210.00 PD
₱100.00 ₱58.00 ₱55.00 ₱103.00 PD
₱60.00 ₱0.00 ₱0.00 ₱60.00 PD
₱70.00 ₱0.00 ₱0.00 ₱70.00 PD
Arrive TOTAL PURCHASE
8/29/2023 ₱1,203.00
8/29/2023
8/29/2023
9/2/2023
8/29/2023
9/5/2023
9/2/2023
9/3/2023
Door matt Bussi
Date Materials Purchase Size
12/30/1899 Ziplock seal transparent bag 28 x 38 cm
8/27/2023 Door matt (Assorted design) 45 x 60 cm
8/31/2023 Printed Label 6.49 X 20.81 cm
DO
Date Materials Qty
8/27/2023 Ziplock seal transparent bag 1
9/1/2023 Door matt (Assorted design) 2
9/1/2023 Printed Label 1
REGISTER
Date Product name Cost price
9/2/2023 1 Pack Door matt (2PCS) ₱93.83
STOCK IN
Date Product name Qty
### 9/4/2023 1 Pack Door matt (2PCS) 4.00
Door matt Bussiness
Qty Unit Price/pcs Amount
10.00 PCS ₱10.30 ₱103.00
8.00 PCS ₱35.00 ₱280.00
4.00 PCS ₱5.00 ₱20.00
DOOR MATT PRICE PER PACK
Size Unit Price/pcs Cost price
28 x 38 cm PCS ₱10.30 ₱10.30
45 x 60 cm PCS ₱35.00 ₱70.00
6.49 X 20.81 cm PCS ₱5.00 ₱5.00
REGISTER
Retail price IS Stock IN Stock OUT
₱100.00 0.00 4.00 1.00
STOCK OUT
Cost Price Total Date Product name
₱93.83 ₱375.32 9/8/2023 1 Pack Door matt (2PCS)
TOTAL
₱403.00

Interest Retail price Price / pack


₱1.03 ₱11.33 ₱93.83
₱7.00 ₱77.00
₱0.50 ₱5.50
TOTAL
Ending Stock NET COST NET SALES NET PROFIT GROSS PROFIT
3.00 ₱375.32 ₱100.00 -₱275.32 -₱817.43
STOCK OUT
Qty Cost price Retail price Profit Total
1.00 ₱93.83 ₱100.00 ₱6.17 ₱100.00
BUDGETING
50% Consumables
Time Date Income
No. Budget Deduction
### 0.00
BUDGETING
30% Investments 10% Enjoyment 10% Savings
Budget Deduction Budget Deduction Budget Deduction
0.00 0.00 0.00
CONSUMABLES
TOTAL BUDGET TOTAL DEDUCTION
₱0.00 ₱0.00 ₱0.00
INVESTMENTS
TOTAL BUDGET TOTAL DEDUCTION
₱0.00 ₱0.00 ₱0.00
ENJOYMENT
TOTAL BUDGET TOTAL DEDUCTION
₱0.00 ₱0.00 ₱0.00
SAVINGS
TOTAL BUDGET TOTAL DEDUCTION
₱0.00 ₱0.00 ₱0.00
TOTAL MONEY
₱0.00
TOTAL INCOME
₱0.00
purchase amount
salamin 45.00 rent
gamit sa house 750.00 utang ki mommy
foods 400.00
water jag and water 185.00
wifi 250.00
1630.00
815.00
2115.00
500.00
800.00
1300.00

You might also like