WhatsApp
Pinterest
Partnership Firm Capital & Profit Sharing Register (Excel)
For partnership firms: work out interest on capital, partners' remuneration and each partner's share of profit in the deed's ratio, with closing capital and the appropriation account.
₹112₹499Save ₹387 (78%)
Inclusive of all taxes · One-time payment · Instant download
See a free sample (PDF) Diwali Sale: 25% off, ends 09 Nov, 12:00 AM
Instant downloadOn screen + email
Secure paymentUPI · Cards · Net Banking
7-day helpFix or refund if faulty
Perfect for
Partnership firms and family businessesAccountants preparing firm accountsCommerce students learning partnership accounts
What you get2 × .xlsx (blank + sample)
Works withMicrosoft Excel · Google Sheets · WPS Office
DeliveryInstant download
LicencePersonal & own-business use
Get the whole Mega BundleBusiness & Work Mega Bundle: Excel, Canva & Office Tools for Shops, Sellers and Companies · ₹3,549 · you save ₹13,054See →
Frequently bought together
This item: Partnership Firm Capital & Profit Sharing Register (Excel)₹112
Cash Book, Day Book & Petty Cash Register (Excel)₹112
Profit & Loss and Balance Sheet Maker for Small Business (Excel)₹187All three: ₹411Sale prices
At year end every partnership firm has to answer the same questions: how much interest does each partner get on capital, what is the remuneration, and how is the rest of the profit split. Doing it by hand invites mistakes and arguments. This register follows the order your deed and the books use.
What it does
- Partners: profit ratio, opening capital, capital added, drawings and remuneration
- Interest on capital at the deed rate on opening capital and half of capital added
- Share of profit after interest and remuneration, in the profit ratio
- Closing capital for each partner
- Appropriation: the profit and loss appropriation account, a check that ratios total 100%, and what each partner gets in total with a chart
Tax note
Income-tax rules (Section 40(b)) limit the interest and remuneration a firm can deduct. Your CA will apply the current limits.
What's inside
Everything you get
01
Partners
Ratio, capital, drawings, remuneration, interest, share
02
Appropriation
Account, checks and each partner's total
03
Settings
Profit and interest rate
04
Blank + sample
Sample firm with 3 partners
Files in your download
- XLSXPartnership_Capital_Profit_Sharing.xlsx13 KB
- XLSXPartnership_Capital_Profit_Sharing_SAMPLE.xlsx13 KB
How to use
Start in 5 simple steps
A step-by-step guide is also included inside your download.
- 1
Enter the profit
Before partners' items
- 2
Set the interest rate
From the deed
- 3
Add each partner
Ratio, capital, drawings, salary
- 4
Check ratios = 100%
On Appropriation
- 5
Share with your CA
For the final accounts
FAQ
Questions about this product
Does it follow the Partnership Act?
It follows the usual order: interest on capital and remuneration as allowed by the deed, then profit in the agreed ratio. Without a deed, the law's default rules apply; ask your CA.
How is interest on capital worked out?
On opening capital for the full year and on capital added for half a year, as a simple average. Change the formula if your deed says otherwise.
Can it handle an LLP?
The idea is similar, but LLPs follow their LLP agreement; the register can still help with the working.
What about interest on drawings?
If your deed charges it, enter it as a negative amount in Remuneration for that partner.
How many partners?
Up to 12.
How do I get the files after payment?
A download button appears on screen right after payment, and the link is emailed to you. You can also download again any time from My account.
Can I use it on my phone?
Yes. It works with Microsoft Excel, Google Sheets, WPS Office. Free mobile apps are enough.
What if something does not work?
Write to us within 7 days with your order number. We will fix it, send a working file, or refund you.
Our promiseEvery file is tested before launch. If something doesn't work, we fix it or refund you within 7 days. Refund policy
Complete the set
Goes well with this
Excel & Sheets
House Help Salary & Attendance Register (Excel): Maid, Cook, Driver, Nanny
Sale₹74₹24970% off
