{"id":31194,"date":"2025-02-03T12:37:47","date_gmt":"2025-02-03T07:07:47","guid":{"rendered":"https:\/\/mybillbook.in\/s\/?page_id=31194"},"modified":"2025-07-24T18:46:32","modified_gmt":"2025-07-24T13:16:32","slug":"receipt-and-payment-account-format","status":"publish","type":"page","link":"https:\/\/mybillbook.in\/s\/receipt-and-payment-account-format\/","title":{"rendered":"Receipt and Payment Account Format"},"content":{"rendered":"<p>[vc_row full_width=&#8221;stretch_row&#8221; css=&#8221;.vc_custom_1703054759629{background-color: #4c3cce !important;}&#8221;][vc_column width=&#8221;1\/2&#8243; offset=&#8221;vc_hidden-md vc_hidden-sm vc_hidden-xs&#8221;][vc_column_text]<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Receipt_and_Payment_Account_Format\"><\/span><span style=\"color: hsl(0, 0%, 100%);\"><strong>Receipt and Payment Account Format<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p><span style=\"color: hsl(0, 0%, 100%);\"><strong>A Receipt and Payment Account is a summary of all cash and bank transactions of an organisation during a specific period. This document can be prepared in Word, Excel, and PDF formats, but using myBillBook makes the process more efficient and automated.<\/strong><\/span><\/p>\n<p><span style=\"color: hsl(0, 0%, 100%);\"><strong>\u2705 Quick &amp; Easy Receipt &amp; Payment Account Generation<\/strong><\/span><\/p>\n<p><span style=\"color: hsl(0, 0%, 100%);\"><strong>\u2705 Customisable Templates<\/strong><\/span><\/p>\n<p><span style=\"color: hsl(0, 0%, 100%);\"><strong>\u2705 Professional Look<\/strong><\/span><\/p>\n<p><span style=\"color: hsl(0, 0%, 100%);\"><strong>\u2705 Unlimited Receipts &amp; Payment Documents<\/strong><\/span><\/p>\n<p><span style=\"color: hsl(0, 0%, 100%);\"><strong>\u2705 Affordable Plans Starting INR 399\/Year<\/strong><\/span>[\/vc_column_text][vc_empty_space]<a itemprop=\"url\" href=\"https:\/\/mybillbook.in\/create-account\" target=\"_self\" style=\"background-color: #db631a;font-size: 15px;font-weight: 500\" class=\"mkdf-btn mkdf-btn-large mkdf-btn-solid\"  >\n    <span class=\"mkdf-btn-text\">Create Receipt and Payment format<\/span>\n    <\/a>[\/vc_column][vc_column css_animation=&#8221;none&#8221; width=&#8221;1\/2&#8243; css=&#8221;.vc_custom_1710411411477{padding-top: 0px !important;}&#8221; offset=&#8221;vc_hidden-md vc_hidden-sm vc_hidden-xs&#8221;][vc_single_image image=&#8221;31199&#8243; img_size=&#8221;large&#8221; alignment=&#8221;center&#8221;][\/vc_column][\/vc_row][vc_row full_width=&#8221;stretch_row&#8221; css=&#8221;.vc_custom_1705558822734{background-color: #ffffff !important;}&#8221;][vc_column][vc_column_text]<\/p>\n<h2 id=\"isPasted\" style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Receipt_and_Payment_Account_Format_in_Word_Excel_PDF_Download_Free\"><\/span><span style=\"color: #4c3cce;\"><b>Receipt and Payment Account Format in Word, Excel &amp; PDF | Download Free<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=&#8221;1\/3&#8243; offset=&#8221;vc_hidden-md vc_hidden-sm vc_hidden-xs&#8221;][vc_single_image image=&#8221;31200&#8243; img_size=&#8221;medium&#8221;][vc_empty_space][vc_btn title=&#8221;Download in Word&#8221; style=&#8221;custom&#8221; custom_background=&#8221;#4c3cce&#8221; custom_text=&#8221;#ffffff&#8221; custom_onclick=&#8221;true&#8221; css=&#8221;.vc_custom_1738675469139{padding-left: 0px !important;}&#8221; link=&#8221;url:https%3A%2F%2Fmybillbook.in%2Fs%2Freceipts-and-payments-account-format-word%2F|target:_blank&#8221;][vc_empty_space][\/vc_column][vc_column width=&#8221;1\/3&#8243; offset=&#8221;vc_hidden-md vc_hidden-sm vc_hidden-xs&#8221;][vc_single_image image=&#8221;31201&#8243; img_size=&#8221;medium&#8221;][vc_empty_space][vc_btn title=&#8221;Download in Excel&#8221; style=&#8221;custom&#8221; custom_background=&#8221;#4c3cce&#8221; custom_text=&#8221;#ffffff&#8221; custom_onclick=&#8221;true&#8221; css=&#8221;.vc_custom_1738675594053{padding-left: 0px !important;}&#8221; link=&#8221;url:https%3A%2F%2Fmybillbook.in%2Fs%2Freceipts-payments-account-format-excel%2F|target:_blank&#8221;][vc_empty_space][\/vc_column][vc_column width=&#8221;1\/3&#8243; offset=&#8221;vc_hidden-md vc_hidden-sm vc_hidden-xs&#8221;][vc_single_image image=&#8221;31203&#8243; img_size=&#8221;medium&#8221;][vc_empty_space][vc_btn title=&#8221;Download in PDF&#8221; style=&#8221;custom&#8221; custom_background=&#8221;#4c3cce&#8221; custom_text=&#8221;#ffffff&#8221; custom_onclick=&#8221;true&#8221; css=&#8221;.vc_custom_1738675605019{padding-left: 0px !important;}&#8221; link=&#8221;url:https%3A%2F%2Fmybillbook.in%2Fs%2Freceipts-and-payments-account-format-pdf%2F|target:_blank&#8221; el_class=&#8221;download-btn&#8221;][vc_empty_space][\/vc_column][\/vc_row][vc_row][vc_column][vc_empty_space][\/vc_column][\/vc_row][vc_row full_width=&#8221;stretch_row&#8221; css=&#8221;.vc_custom_1703058114563{background-color: #4c3cce !important;}&#8221;][vc_column][vc_column_text]<\/p>\n<h2 style=\"text-align: left; color: #292d35; font-size: 30px; border: 0px;\"><span class=\"ez-toc-section\" id=\"Features_of_myBillBook_Receipt_and_Payment_Account_Format\"><\/span><strong><span style=\"color: #ffffff;\">Features of myBillBook Receipt and Payment Account Format<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>[\/vc_column_text][vc_empty_space][\/vc_column][\/vc_row][vc_row full_width=&#8221;stretch_row&#8221; css=&#8221;.vc_custom_1703054816580{background-color: #4c3cce !important;}&#8221;][vc_column width=&#8221;1\/3&#8243;][vc_single_image image=&#8221;27111&#8243;][vc_column_text]<\/p>\n<h3 style=\"color: #292d35; font-size: 20px; text-align: left;\"><span style=\"color: #ffffff;\">Automated Calculations<\/span><\/h3>\n<p style=\"color: #ffffff; font-size: 16px; text-align: left;\">The system automatically calculates totals for receipts and payments, reducing the likelihood of errors and saving time. This feature ensures that financial records remain accurate and consistent without the need for manual intervention.<\/p>\n<p>[\/vc_column_text][\/vc_column][vc_column width=&#8221;1\/3&#8243;][vc_single_image image=&#8221;27117&#8243;][vc_column_text]<\/p>\n<h3 style=\"color: #292d35; font-size: 20px; text-align: left;\"><span style=\"color: #ffffff;\">Customisable Formats<\/span><\/h3>\n<p style=\"color: #ffffff; font-size: 16px; text-align: left;\">Users can select from a variety of predefined templates or modify them to create a unique layout suited to their specific requirements. This flexibility allows organisations to maintain a consistent format in their financial documentation.<\/p>\n<p>[\/vc_column_text][\/vc_column][vc_column width=&#8221;1\/3&#8243;][vc_single_image image=&#8221;27114&#8243;][vc_column_text]<\/p>\n<h3 style=\"color: #292d35; font-size: 20px; text-align: left;\"><span style=\"color: #ffffff;\">Excel &amp; PDF Export Options<\/span><\/h3>\n<p style=\"color: #ffffff; font-size: 16px; text-align: left;\">The ability to export documents in both Excel and PDF formats ensures ease of sharing and accessibility. Users can leverage Excel for editing and calculations, while PDFs offer a secure and professional format for reporting and record-keeping.<\/p>\n<p>[\/vc_column_text][\/vc_column][\/vc_row][vc_row full_width=&#8221;stretch_row&#8221; css=&#8221;.vc_custom_1703054830439{background-color: #4c3cce !important;}&#8221;][vc_column width=&#8221;1\/3&#8243;][vc_single_image image=&#8221;27118&#8243;][vc_column_text]<\/p>\n<h3 style=\"color: #292d35; font-size: 20px; text-align: left;\"><span style=\"color: #ffffff;\">Cloud Storage<\/span><\/h3>\n<p style=\"color: #ffffff; font-size: 16px; text-align: left;\">Secure cloud-based storage allows users to save and access receipts and payment accounts from any device, ensuring that data is never lost due to hardware failures or accidental deletions. This also enables remote work and multi-location access.<\/p>\n<p>[\/vc_column_text][\/vc_column][vc_column width=&#8221;1\/3&#8243;][vc_single_image image=&#8221;27115&#8243;][vc_column_text]<\/p>\n<h3 style=\"color: #292d35; font-size: 20px; text-align: left;\"><span style=\"color: #ffffff;\">Multi-User Access<\/span><\/h3>\n<p style=\"color: #ffffff; font-size: 16px; text-align: left;\">Organizations can grant access to multiple users, facilitating collaboration and improved financial management. This feature is particularly useful for teams handling finances collectively, allowing real-time updates and edits to be made seamlessly.<\/p>\n<p>[\/vc_column_text][\/vc_column][vc_column width=&#8221;1\/3&#8243;][vc_single_image image=&#8221;26738&#8243;][vc_column_text]<\/p>\n<h3 style=\"color: #292d35; font-size: 20px; text-align: left;\"><span style=\"color: #ffffff;\">Affordable &amp; Cost-Effective<\/span><\/h3>\n<p style=\"color: #ffffff; font-size: 16px; text-align: left;\">With budget-friendly plans starting at INR 399 per year, myBillBook provides professional accounting tools at a fraction of the cost of traditional <a href=\"https:\/\/mybillbook.in\/s\/free-accounting-software\/\">accounting software<\/a>. This ensures that businesses and non-profits can maintain high-quality financial records without incurring high expenses.<\/p>\n<p>[\/vc_column_text][\/vc_column][vc_column offset=&#8221;vc_hidden-md vc_hidden-sm vc_hidden-xs&#8221;]<a itemprop=\"url\" href=\"https:\/\/mybillbook.in\/create-account\/\" target=\"_self\" style=\"color: #ffffff;background-color: #db631a;font-size: 20px;font-weight: 400;margin: 0px 0px 0px 50px\" class=\"mkdf-btn mkdf-btn-huge mkdf-btn-solid\"  >\n    <span class=\"mkdf-btn-text\">START 14-DAY FREE TRIAL<\/span>\n    <\/a>[vc_empty_space][\/vc_column][\/vc_row][vc_row css=&#8221;.vc_custom_1709216208269{background-color: #ffffff !important;}&#8221;][vc_column width=&#8221;1\/3&#8243; css=&#8221;.vc_custom_1710411716069{background-color: #ffffff !important;}&#8221; offset=&#8221;vc_hidden-md vc_hidden-sm vc_hidden-xs&#8221;][vc_column_text]<\/p>\n<p style=\"text-align: center; color: #82b541; font-size: 48px;\"><strong><b>\u20b9217<\/b><\/strong><\/p>\n<p style=\"text-align: center; color: #888888; font-size: 14px;\"><span style=\"font-size: 18px;\">Per month. Billed annually<\/span><\/p>\n<h5 style=\"text-align: center; color: #444444; font-size: 20px;\"><strong><strong><span style=\"font-size: 24px;\">Diamond Plan<\/span><\/strong><\/strong><\/h5>\n<p style=\"text-align: left; color: #444444; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 Create unlimited invoices<\/span><\/p>\n<p style=\"text-align: left; color: #444444; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 Add up to 1 business + 1 user<\/span><\/p>\n<p style=\"text-align: left; color: #444444; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 Inventory management<\/span><\/p>\n<p style=\"text-align: left; color: #444444; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 App + Web support<\/span><\/p>\n<p style=\"text-align: left; color: #444444; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 Priority customer support<\/span><\/p>\n<p style=\"text-align: left; color: #444444; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 GSTR reports in JSON format\u00a0<\/span><span style=\"color: #db631a; font-size: 14px;\">Popular<\/span><\/p>\n<p>[\/vc_column_text][vc_empty_space]<a itemprop=\"url\" href=\"https:\/\/mybillbook.in\/create-account\" target=\"_self\" style=\"color: #ffffff;background-color: #db631a\" class=\"mkdf-btn mkdf-btn-large mkdf-btn-solid\"  >\n    <span class=\"mkdf-btn-text\">START 14-DAY FREE TRIAL<\/span>\n    <\/a>[vc_empty_space height=&#8221;16px&#8221;][\/vc_column][vc_column width=&#8221;1\/3&#8243; css=&#8221;.vc_custom_1710411723091{background-color: #db631a !important;}&#8221; offset=&#8221;vc_hidden-md vc_hidden-sm vc_hidden-xs&#8221;][vc_column_text]<\/p>\n<p style=\"text-align: center; color: #ffffff; font-size: 48px;\"><strong><strong>\u20b9250<\/strong><\/strong><\/p>\n<p style=\"text-align: center; color: #ffffff; font-size: 14px;\"><span style=\"font-size: 18px;\">Per month. Billed annually<\/span><\/p>\n<h5 style=\"text-align: center; color: #ffffff; font-size: 20px;\"><strong><strong><span style=\"font-size: 24px;\">Platinum Plan<\/span><\/strong><\/strong><\/h5>\n<p style=\"text-align: left; color: #ffffff; font-size: 14px;\"><strong><span style=\"font-size: 14px;\">Everything on Diamond Plan +<\/span><\/strong><\/p>\n<p style=\"text-align: left; color: #ffffff; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 Add up to 2 business + 2 user<\/span><\/p>\n<p style=\"text-align: left; color: #ffffff; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 50 e-Way bills\/year<\/span><\/p>\n<p style=\"text-align: left; color: #ffffff; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 Staff attendance + payroll<\/span><\/p>\n<p style=\"text-align: left; color: #ffffff; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 Godown management<\/span><\/p>\n<p style=\"text-align: left; color: #ffffff; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 Whatsapp and SMS marketing\u00a0<\/span><span style=\"color: #fffd01; font-size: 14px;\">Popular<\/span><\/p>\n<p>[\/vc_column_text][vc_empty_space]<a itemprop=\"url\" href=\"https:\/\/mybillbook.in\/create-account\" target=\"_self\" style=\"color: #000000;background-color: #ffffff;border-color: #000000\" class=\"mkdf-btn mkdf-btn-large mkdf-btn-solid\"  >\n    <span class=\"mkdf-btn-text\">START 14-DAY FREE TRIAL<\/span>\n    <\/a>[vc_empty_space height=&#8221;16px&#8221;][\/vc_column][vc_column width=&#8221;1\/3&#8243; offset=&#8221;vc_hidden-md vc_hidden-sm vc_hidden-xs&#8221;][vc_column_text]<\/p>\n<p style=\"text-align: center; color: #82b541; font-size: 48px;\"><strong><b>\u20b9417<\/b><\/strong><\/p>\n<p style=\"text-align: center; color: #888888; font-size: 14px;\"><span style=\"font-size: 18px;\">Per month. Billed annually<\/span><\/p>\n<h5 style=\"text-align: center; color: #444444; font-size: 20px;\"><strong><strong><span style=\"font-size: 24px;\">Enterprise Plan<\/span><\/strong><\/strong><\/h5>\n<p style=\"text-align: left; color: #444444; font-size: 14px;\"><strong><span style=\"font-size: 14px;\">Everything on Platinum Plan +<\/span><\/strong><\/p>\n<p style=\"text-align: left; color: #444444; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 Custom invoice themes<\/span><\/p>\n<p style=\"text-align: left; color: #444444; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 Create your online store<\/span><\/p>\n<p style=\"text-align: left; color: #444444; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 Generate and print barcode<\/span><\/p>\n<p style=\"text-align: left; color: #444444; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 POS billing on desktop app<\/span><\/p>\n<p style=\"text-align: left; color: #444444; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 Unlimited e-Invoices &amp; e-Way bills\u00a0<\/span><span style=\"color: #db631a; font-size: 14px;\">Popular<\/span><\/p>\n<p>[\/vc_column_text][vc_empty_space]<a itemprop=\"url\" href=\"https:\/\/mybillbook.in\/create-account\" target=\"_self\" style=\"color: #ffffff;background-color: #db631a\" class=\"mkdf-btn mkdf-btn-large mkdf-btn-solid\"  >\n    <span class=\"mkdf-btn-text\">START 14-DAY FREE TRIAL<\/span>\n    <\/a>[vc_empty_space height=&#8221;16px&#8221;][\/vc_column][\/vc_row][vc_row][vc_column width=&#8221;1\/2&#8243; offset=&#8221;vc_hidden-md vc_hidden-sm vc_hidden-xs&#8221;][vc_single_image image=&#8221;27457&#8243; img_size=&#8221;full&#8221;][\/vc_column][vc_column width=&#8221;1\/2&#8243; offset=&#8221;vc_hidden-md vc_hidden-sm vc_hidden-xs&#8221;][vc_empty_space][vc_empty_space][vc_column_text]<\/p>\n<p style=\"text-align: left; color: #82b541; font-size: 48px;\"><strong><b style=\"color: #4c3cce;\">\u20b9399<span style=\"font-size: 24px;\">\u00a0per year<\/span><\/b><\/strong><\/p>\n<h5 style=\"text-align: left; color: #444444; font-size: 20px;\"><strong><strong><span style=\"font-size: 24px;\">Silver Plan for Android App<\/span><\/strong><\/strong><\/h5>\n<p style=\"text-align: left; color: #444444; font-size: 14px;\"><span style=\"font-size: 16px;\">\u2705 For 1 device, 1 business and 1 user<\/span><\/p>\n<p>[\/vc_column_text][vc_empty_space]<a itemprop=\"url\" href=\"https:\/\/mybillbook.in\/create-account\" target=\"_self\" style=\"color: #ffffff;background-color: #4b3ccd\" class=\"mkdf-btn mkdf-btn-large mkdf-btn-solid\"  >\n    <span class=\"mkdf-btn-text\">START 14-DAY FREE TRIAL<\/span>\n    <\/a>[\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_is_a_Receipt_and_Payment_Account\"><\/span>What is a Receipt and Payment Account?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">A Receipt and Payment Account is a summary cash book that records all cash and bank transactions of an entity over a financial period. Unlike an income and expenditure account, it does not show the surplus or deficit but only captures cash inflows and outflows. It is prepared on a cash basis and does not account for outstanding expenses or accrued income.<\/span>[\/vc_column_text][vc_column_text]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Format_of_Receipt_and_Payment_Account\"><\/span>Format of Receipt and Payment Account<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The <\/span><b>format<\/b><span style=\"font-weight: 400;\"> of a receipt and payment account consists of two columns:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Receipts (Dr)<\/b><\/td>\n<td><b>Payments (Cr)<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Opening Cash Balance<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Salaries &amp; Wages Paid<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Subscriptions Received<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Rent &amp; Utilities Paid<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Donations<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Purchase of Equipment<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Interest Received<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Office Expenses<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Sale of Old Assets<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Loan Repayment<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Any Other Income<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Closing Cash Balance<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400;\">This format provides a clear overview of all cash inflows and outflows in a structured manner.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Key_Elements_of_a_Receipt_and_Payment_Account\"><\/span>Key Elements of a Receipt and Payment Account<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Opening Balance<\/b><span style=\"font-weight: 400;\"> \u2013 The amount of cash and bank balance at the start of the period.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Receipts<\/b><span style=\"font-weight: 400;\"> \u2013 All cash and bank inflows, including donations, subscriptions, and interest received.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Payments<\/b><span style=\"font-weight: 400;\"> \u2013 All cash and bank outflows, including salaries, rent, and expenses.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Closing Balance<\/b><span style=\"font-weight: 400;\"> \u2013 The remaining cash and bank balance at the end of the period.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Non-Profit Context<\/b><span style=\"font-weight: 400;\"> \u2013 Used mainly by non-profits, clubs, and institutions rather than businesses.<\/span><\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Example_of_a_Receipt_and_Payment_Account\"><\/span>Example of a Receipt and Payment Account<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table>\n<tbody>\n<tr>\n<td><b>Receipts<\/b><\/td>\n<td><b>Amount (INR)<\/b><\/td>\n<td><b>Payments<\/b><\/td>\n<td><b>Amount (INR)<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Opening Balance<\/span><\/td>\n<td><span style=\"font-weight: 400;\">20,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Salaries<\/span><\/td>\n<td><span style=\"font-weight: 400;\">5,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Subscriptions<\/span><\/td>\n<td><span style=\"font-weight: 400;\">15,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Rent<\/span><\/td>\n<td><span style=\"font-weight: 400;\">3,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Donations<\/span><\/td>\n<td><span style=\"font-weight: 400;\">10,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Office Expenses<\/span><\/td>\n<td><span style=\"font-weight: 400;\">2,500<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Interest Received<\/span><\/td>\n<td><span style=\"font-weight: 400;\">2,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Purchase of Equipment<\/span><\/td>\n<td><span style=\"font-weight: 400;\">7,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Total<\/span><\/td>\n<td><span style=\"font-weight: 400;\">47,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Total<\/span><\/td>\n<td><span style=\"font-weight: 400;\">17,500<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Closing Balance<\/span><\/td>\n<td><span style=\"font-weight: 400;\">29,500<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>[\/vc_column_text][vc_column_text]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Receipt_and_Payment_Account_Format_in_Excel_Word_PDF\"><\/span>Receipt and Payment Account Format in Excel, Word &amp; PDF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Creating a receipt and payment account can be done in Word, Excel, and PDF, each offering its unique advantages.\u00a0<\/span><\/p>\n<h3>Steps to Create in Excel:<\/h3>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Open Excel and create a table with two columns: <\/span><b>Receipts<\/b><span style=\"font-weight: 400;\"> and <\/span><b>Payments<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">List down all cash inflows under Receipts and all outflows under Payments.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use formulas like <\/span><span style=\"font-weight: 400;\">=SUM(range)<\/span><span style=\"font-weight: 400;\"> to calculate totals automatically.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Format the table using borders and bold headings for clarity.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Save as an Excel sheet or convert it to a PDF for sharing.<\/span><\/li>\n<\/ol>\n<h3>Steps to Create in Word:<\/h3>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Open Word and create a table with two columns: <\/span><b>Receipts<\/b><span style=\"font-weight: 400;\"> and <\/span><b>Payments<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Enter all financial transactions, ensuring clear formatting.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Adjust font styles and table formatting for a professional appearance.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Save the document and export it as a PDF if needed.<\/span><\/li>\n<\/ol>\n<h3>Steps to Create in PDF:<\/h3>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use a template or create the receipt and payment account in Word or Excel.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Convert the document to PDF for easy sharing and secure record-keeping.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ensure the document is properly formatted and locked for official use.<\/span><\/li>\n<\/ol>\n<p>[\/vc_column_text][vc_column_text]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Best_Practices_for_Creating_and_Using_Receipt_Payment_Accounts\"><\/span>Best Practices for Creating and Using Receipt &amp; Payment Accounts<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Record Transactions Regularly<\/b><span style=\"font-weight: 400;\"> \u2013 Avoid missing transactions by updating records daily.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Use Software for Accuracy<\/b><span style=\"font-weight: 400;\"> \u2013 Excel helps with calculations, but myBillBook provides automated tracking.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Categorize Receipts &amp; Payments<\/b><span style=\"font-weight: 400;\"> \u2013 Grouping transactions makes financial reporting more transparent.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Ensure Year-End Reconciliation<\/b><span style=\"font-weight: 400;\"> \u2013 Compare the closing balance with actual bank and cash balances.<\/span><\/li>\n<li aria-level=\"1\"><b>Maintain Digital Backups<\/b><span style=\"font-weight: 400;\"> \u2013 Storing records in cloud-based platforms ensures easy retrieval and safety.<\/span><\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column offset=&#8221;vc_hidden-md vc_hidden-sm vc_hidden-xs&#8221;][vc_empty_space]<a itemprop=\"url\" href=\"https:\/\/mybillbook.in\/create-account\/\" target=\"_self\" style=\"color: #ffffff;background-color: #4b3ccd;font-size: 20px;font-weight: 400;margin: 0px 0px 0px 50px\" class=\"mkdf-btn mkdf-btn-huge mkdf-btn-solid\"  >\n    <span class=\"mkdf-btn-text\">START 14-DAY FREE TRIAL<\/span>\n    <\/a>[vc_empty_space][\/vc_column][\/vc_row][vc_row full_width=&#8221;stretch_row&#8221; css=&#8221;.vc_custom_1703058401061{background-color: #ededed !important;}&#8221;][vc_column][vc_column_text]<\/p>\n<h3>FAQs<\/h3>\n<p>[\/vc_column_text][vc_column_text]<b>1. What is the main purpose of a Receipt and Payment Account?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">It provides a summary of all cash and bank transactions within a financial period, mainly for non-profit organizations and institutions.<\/span><\/p>\n<p><b>2. How does a Receipt and Payment Account differ from an Income and Expenditure Account?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">A receipt and payment account records only cash transactions, while an income and expenditure account considers both cash and non-cash transactions, including outstanding liabilities and accrued income.<\/span><\/p>\n<p><b>3. Can a Receipt and Payment Account show a deficit or surplus?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">No, it only records receipts and payments without calculating profits or losses.<\/span><\/p>\n<p><b>4. Why is Excel preferred for preparing a Receipt and Payment Account?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Excel provides automated calculations, structured formatting, and easy data modifications, making financial record-keeping more efficient.<\/span><\/p>\n<p><b>5. How can myBillBook simplify Receipt and Payment Account creation?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">myBillBook offers <\/span><b>automated templates, cloud storage, and multi-user access<\/b><span style=\"font-weight: 400;\">, making it a more efficient solution than manual preparation in Word or Excel.<\/span>[\/vc_column_text][vc_empty_space][\/vc_column][\/vc_row][vc_section][vc_row][vc_column][vc_empty_space][vc_column_text]<\/p>\n<h3 style=\"text-align: center;\"><b>Know More About Accounting &amp; Billing Formats<\/b><\/h3>\n<p>[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=&#8221;1\/3&#8243;][vc_column_text]<\/p>\n<ul>\n<li><a href=\"https:\/\/mybillbook.in\/s\/cash-memo-format\/\"><span style=\"font-weight: 400;\">Cash Memo Format<\/span><\/a><\/li>\n<li><a href=\"https:\/\/mybillbook.in\/s\/manufacturing-account-format\/\"><span style=\"font-weight: 400;\">Manufacturing Account format<\/span><\/a><\/li>\n<li><a href=\"https:\/\/mybillbook.in\/s\/quotation-format\/\"><span style=\"font-weight: 400;\">Quotation Format<\/span><\/a><\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_column][vc_column width=&#8221;1\/3&#8243;][vc_column_text]<\/p>\n<ul>\n<li><a href=\"https:\/\/mybillbook.in\/s\/purchase-order-format\/\"><span style=\"font-weight: 400;\">Purchase Order Format<\/span><\/a><\/li>\n<li><a href=\"https:\/\/mybillbook.in\/s\/hotel-bill-format\/\"><span style=\"font-weight: 400;\">Hotel Bill Format<\/span><\/a><\/li>\n<li><a href=\"https:\/\/mybillbook.in\/s\/capital-account-format\/\"><span style=\"font-weight: 400;\">Capital Account format<\/span><\/a><\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_column][vc_column width=&#8221;1\/3&#8243;][vc_column_text]<\/p>\n<ul>\n<li><a href=\"https:\/\/mybillbook.in\/s\/accounting\/profit-and-loss-account-format\/\"><span style=\"font-weight: 400;\">Profit and loss Account Format<\/span><\/a><\/li>\n<li><a href=\"https:\/\/mybillbook.in\/s\/depreciation-account-format\/\"><span style=\"font-weight: 400;\">Depreciation Account Format<\/span><\/a><\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_column][\/vc_row][\/vc_section][vc_row][vc_column][vc_empty_space][\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"[vc_row full_width=\"stretch_row\" css=\".vc_custom_1703054759629{background-color: #4c3cce !important;}\"][vc_column width=\"1\/2\" offset=\"vc_hidden-md vc_hidden-sm vc_hidden-xs\"][vc_column_text] Receipt and Payment Account Format A Receipt and Payment Account is a summary of all cash and bank transactions of an organisation during a specific period. This document can be prepared [...]","protected":false},"author":22,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.5.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Receipt and Payment Account Format | Download Free Excel<\/title>\n<meta name=\"description\" content=\"Learn the format of receipts and payment accounts in Excel, with examples. Explore the receipt and expenditure account format for better financial tracking.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mybillbook.in\/s\/receipt-and-payment-account-format\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Receipt and Payment Account Format | Download Free Excel\" \/>\n<meta property=\"og:description\" content=\"Learn the format of receipts and payment accounts in Excel, with examples. Explore the receipt and expenditure account format for better financial tracking.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mybillbook.in\/s\/receipt-and-payment-account-format\/\" \/>\n<meta property=\"og:site_name\" content=\"myBillBook\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-24T13:16:32+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Receipt and Payment Account Format | Download Free Excel","description":"Learn the format of receipts and payment accounts in Excel, with examples. Explore the receipt and expenditure account format for better financial tracking.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/mybillbook.in\/s\/receipt-and-payment-account-format\/","og_locale":"en_US","og_type":"article","og_title":"Receipt and Payment Account Format | Download Free Excel","og_description":"Learn the format of receipts and payment accounts in Excel, with examples. Explore the receipt and expenditure account format for better financial tracking.","og_url":"https:\/\/mybillbook.in\/s\/receipt-and-payment-account-format\/","og_site_name":"myBillBook","article_modified_time":"2025-07-24T13:16:32+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/mybillbook.in\/s\/receipt-and-payment-account-format\/","url":"https:\/\/mybillbook.in\/s\/receipt-and-payment-account-format\/","name":"Receipt and Payment Account Format | Download Free Excel","isPartOf":{"@id":"https:\/\/mybillbook.in\/s\/#website"},"datePublished":"2025-02-03T07:07:47+00:00","dateModified":"2025-07-24T13:16:32+00:00","description":"Learn the format of receipts and payment accounts in Excel, with examples. Explore the receipt and expenditure account format for better financial tracking.","breadcrumb":{"@id":"https:\/\/mybillbook.in\/s\/receipt-and-payment-account-format\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mybillbook.in\/s\/receipt-and-payment-account-format\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/mybillbook.in\/s\/receipt-and-payment-account-format\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mybillbook.in\/s\/"},{"@type":"ListItem","position":2,"name":"Receipt and Payment Account Format"}]},{"@type":"WebSite","@id":"https:\/\/mybillbook.in\/s\/#website","url":"https:\/\/mybillbook.in\/s\/","name":"myBillBook","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mybillbook.in\/s\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/mybillbook.in\/s\/wp-json\/wp\/v2\/pages\/31194"}],"collection":[{"href":"https:\/\/mybillbook.in\/s\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/mybillbook.in\/s\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/mybillbook.in\/s\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/mybillbook.in\/s\/wp-json\/wp\/v2\/comments?post=31194"}],"version-history":[{"count":8,"href":"https:\/\/mybillbook.in\/s\/wp-json\/wp\/v2\/pages\/31194\/revisions"}],"predecessor-version":[{"id":32848,"href":"https:\/\/mybillbook.in\/s\/wp-json\/wp\/v2\/pages\/31194\/revisions\/32848"}],"wp:attachment":[{"href":"https:\/\/mybillbook.in\/s\/wp-json\/wp\/v2\/media?parent=31194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}