Bank P.D.C Tracking & Clearance Planner
Budget: ₹600 – ₹1,500 INR
I need a Google sheet that can help me track the Post-Dated Cheques (P.D.Cs) from different banks.
Key Features:
- Track Amounts: The sheet should allow me to input the amount of each cheque.
- Pending Cheques: It should have a section where I can input the dates of the P.D.Cs that are yet to be presented.
- Upcoming Clearances: The sheet should automatically calculate the total amount required for cheque clearances on a specific date.
- Color-coded Dates: I'd like the dates to be color-coded so I can easily identify upcoming cheque clearances.
NEED A CLOUMN OF CHEQUES NUMBER AND PARTY NAME AND AMOUNT
I WILL TICK ON CHEQUES WHICH ARE CLEARED ON DAILY BASIS
Skills & Experience:
- Advanced proficiency in Google Sheets
- Experience in creating automated calculations and conditional formatting
- Familiarity with financial tracking and banking terminology may be beneficial
If you're confident in your ability to create this system efficiently and accurately, I'd love to hear from you!
Key Features:
- Track Amounts: The sheet should allow me to input the amount of each cheque.
- Pending Cheques: It should have a section where I can input the dates of the P.D.Cs that are yet to be presented.
- Upcoming Clearances: The sheet should automatically calculate the total amount required for cheque clearances on a specific date.
- Color-coded Dates: I'd like the dates to be color-coded so I can easily identify upcoming cheque clearances.
NEED A CLOUMN OF CHEQUES NUMBER AND PARTY NAME AND AMOUNT
I WILL TICK ON CHEQUES WHICH ARE CLEARED ON DAILY BASIS
Skills & Experience:
- Advanced proficiency in Google Sheets
- Experience in creating automated calculations and conditional formatting
- Familiarity with financial tracking and banking terminology may be beneficial
If you're confident in your ability to create this system efficiently and accurately, I'd love to hear from you!