Podcast
Play an AI-generated podcast conversation about this lesson
Questions and Answers
What is the date mentioned on the invoice?
What is the date mentioned on the invoice?
02-10-2023
What service was provided to Plumis Ltd?
What service was provided to Plumis Ltd?
- Legal Consultation Service
- Accounts & Finance Outsourcing Service (correct)
- IT Support Service
- Marketing Campaign Service
The total amount mentioned on the invoice is ₹ ___.
The total amount mentioned on the invoice is ₹ ___.
70,000.00
What is the purpose of linking Google Sheet in our website?
What is the purpose of linking Google Sheet in our website?
Signup and view all the answers
What happens if the subscription is not renewed?
What happens if the subscription is not renewed?
Signup and view all the answers
What do you need to select for payment reminders?
What do you need to select for payment reminders?
Signup and view all the answers
What is the purpose of the Report tab?
What is the purpose of the Report tab?
Signup and view all the answers
What are the types of reports that can be generated from the Report tab?
What are the types of reports that can be generated from the Report tab?
Signup and view all the answers
What is the fifth report that can be generated from the Report tab?
What is the fifth report that can be generated from the Report tab?
Signup and view all the answers
Flashcards are hidden until you start studying
Study Notes
Invoice Details
- Invoice date: 02-10-2023
- Invoice number: DS013
Company Information
- Company address: A/201, Haridham Complex, Jayratna Cross Road, R.V.Desai Road, Vadodara, Gujarat - 390001
- State code: 24
- Phone number: +91 7600366588
- Email: [email protected]
Bill To
- Company name: Plumis Ltd
Items and Charges
- Item description: Accounts & Finance Outsourcing Service
- Quantity: 1
- Rate: ₹ 70,000.00
- Amount: ₹ 70,000.00
Payment Details
- Bank name: State Bank of India
- Account holder name: Deep Shah
- Account number: 36186790000
- IFSC code: SBIN0013480
- Total amount: ₹ 70,000.00
- Total amount in words: Seventy Thousand Rupees Only
Managing Subscriptions with Razorpay and Google Sheet
- Manage website subscriptions monthly or annually using Razorpay
- Link Google Sheet to track subscription payments and automate reminders
Setting Up Payment Reminders
- Select a template for payment reminders
- Choose the number of reminders and interval days
Report Generation
- Add a Report tab to read data from Google Sheet and generate reports on screen
Report Details
- Total Outstanding Amount
- Outstanding Amount by Customer
- Outstanding Amount by Due Date:
- Due today
- Due tomorrow
- Due within next week
- Due within next month
- Overdue
- Top 10 Customers by Outstanding Amount
- Percentage of Total Revenue Outstanding
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
