{"id":29710,"date":"2025-06-30T14:25:57","date_gmt":"2025-06-30T14:25:57","guid":{"rendered":"https:\/\/synder.com\/blog\/?p=29710"},"modified":"2026-01-26T12:43:14","modified_gmt":"2026-01-26T12:43:14","slug":"the-ultimate-guide-to-manual-revenue-recognition","status":"publish","type":"post","link":"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/","title":{"rendered":"The Ultimate Guide to Manual Revenue Recognition"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Your business might not need full-scale revenue recognition automation just yet, but that doesn\u2019t mean compliance has to be a burden.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This comprehensive guide is designed for businesses with lower transaction volumes, offering a meticulous guide to manually tracking your revenue recognition. We&#8217;ll show you how to leverage <a href=\"https:\/\/synder.com\/industry\/syndersync\/\">Synder Sync<\/a> as your reliable source of truth for transaction data and ensure accuracy and compliance with essential standards like ASC 606 (U.S. GAAP) and IFRS 15.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It all comes down to one key idea: recognize revenue when the customer gets what they paid for, not when the money hits your account. Here\u2019s how that works in practice.<\/p>\n\n\n\n<h2 id=\"how-to-create-a-revenue-recognition-schedule\" class=\"wp-block-heading\"><strong>How to create a revenue recognition schedule<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">So, you&#8217;re running a business that sells subscriptions, or maybe you&#8217;ve got long-term service gigs. You get paid, but you haven&#8217;t actually <em>delivered<\/em> all the goods or services yet. That&#8217;s exactly why you need a revenue recognition schedule. You might hear it called a waterfall schedule or a deferred revenue waterfall.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The schedule tracks how the upfront cash: \u201cunearned\u201d or \u201cdeferred\u201d revenue, gradually becomes \u201cearned\u201d or \u201crecognized\u201d revenue as you deliver the product or service. This schedule effectively bridges the timing difference between when you receive payment and when you actually deliver the goods or services to the customer, aligning your financials with GAAP and IFRS 15.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We\u2019re going to show you how to build one now. Grab a spreadsheet (Excel&#8217;s usually the go-to) and let&#8217;s dive into how to set up a solid revenue recognition schedule!<\/p>\n\n\n\n<h3 id=\"1-gather-your-key-data-inputs\" class=\"wp-block-heading\"><strong>1. Gather your key data inputs<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Before you begin constructing the schedule, you&#8217;ll need comprehensive information for each contract or specific performance obligation that will be recognized over time. This data is the foundation of your waterfall.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This includes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A unique Contract\/Invoice ID (e.g., &#8220;C001-PO-02&#8221;)<\/li>\n\n\n\n<li>A description of the good or service (e.g., &#8220;12-Month SaaS Subscription&#8221;)<\/li>\n\n\n\n<li>Customer name<\/li>\n\n\n\n<li>Start date and end date of the performance obligation<\/li>\n\n\n\n<li>Total allocated transaction price for each obligation<\/li>\n\n\n\n<li>Recognition method&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">While some of these items, like customer name or contract ID are pretty self-explenatory, the two last concepts can cause confusion, so let\u2019s take a moment to clarify them.<\/p>\n\n\n\n<h4 id=\"total-allocated-transaction-price\" class=\"wp-block-heading\"><strong>Total allocated transaction price<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">The total allocated transaction price is just the amount your company expects to earn for delivering a specific part of what you promised in a contract\u2014what accountants call a \u201cperformance obligation.\u201d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here&#8217;s a breakdown:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Transaction price:<\/strong> This is the grand total of what you expect to get paid from a customer for everything you&#8217;ve promised them in a contract. It could be a set price, or it might change a bit based on things like discounts, bonuses, or even penalties.<\/li>\n\n\n\n<li><strong>Performance obligation:<\/strong> A performance obligation is a specific promise to transfer a good or service to a customer. It can also be explained as a product or item included in a particular invoice.&nbsp; A single contract might have multiple performance obligations. For example, a software contract could include a software license (one performance obligation) and ongoing support services (another performance obligation).<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table cnvs-block-core-table-1751291986555\"><table class=\"has-gray-200-background-color has-background has-fixed-layout\"><tbody><tr><td><strong><em>Note<\/em><\/strong>: In practice, it\u2019s not always necessary to break down invoices into every individual item. In some cases, especially if you don&#8217;t track individual products or services in your accounting system or don&#8217;t need that level of detail for tax reporting, it may be easier to recognize the invoice as a whole. This is especially true when the invoice represents a single, clearly defined performance obligation.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Allocation:<\/strong> When a contract bundles several promises, you can\u2019t treat the payment as one big pot. Split it among the specific performance obligations instead. A good rule of thumb: price each product or service as if you were selling it on its own, then use those standalone prices to apportion the revenue so every promise gets the share that matches its real value.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">So, the total allocated transaction price for one specific performance obligation is simply the part of the overall contract&#8217;s value that&#8217;s tied to that particular good or service. And that&#8217;s the exact amount you&#8217;ll eventually record as revenue once you&#8217;ve actually delivered on that promise.<\/p>\n\n\n\n<figure class=\"wp-block-table cnvs-block-core-table-1751292048722\"><table class=\"has-gray-200-background-color has-background has-fixed-layout\"><tbody><tr><td><strong><em>Example<\/em><\/strong>: Imagine &#8220;Software Solutions Inc&#8221;. signs a contract with a client for $10,000. This contract includes a software license and one year of support services.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Software Solutions Inc. needs to split the $10,000 between these two parts based on what they&#8217;d charge if sold separately:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The software license is valued at $8,000.<\/li>\n\n\n\n<li>The one year of support services is valued at $2,000.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">So:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The total allocated transaction price for the software license is $8,000.<\/li>\n\n\n\n<li>The total allocated transaction price for the support services is $2,000.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">This ensures revenue is recorded accurately for each specific promise made in the contract.<\/p>\n\n\n\n<h4 id=\"recognition-method-time-elapsed-ratable\" class=\"wp-block-heading\"><strong>Recognition method: Time elapsed (ratable)<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">The recognition method dictates <em>when<\/em> and <em>how<\/em> the allocated transaction price for a performance obligation is recognized as revenue in your financial statements.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Revenue can generally be recognized in two main ways:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>At a point in time:<\/strong> This is for goods or services where control is transferred to the customer at a specific moment. For instance, when a customer buys a physical product, the revenue is typically recognized when they receive the product.<\/li>\n\n\n\n<li><strong>Over time:<\/strong> This method is best for services where the customer is benefiting from what you&#8217;re doing continuously, as you&#8217;re doing it. It\u2019s the recommended method to use if you&#8217;re running a SaaS company or other subscription businesses. For example, if someone signs up for a year of your software, they&#8217;re using it every day of that year. So, instead of recognizing all the revenue upfront, you spread it out over the entire year as they continue to use and benefit from your service.&nbsp;<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Time elapsed (ratable)<\/strong> is a common &#8220;over time&#8221; recognition method, particularly for subscription-based services like SaaS or maintenance contracts. In these scenarios, the customer benefits from the service throughout the contract period. For example, with a 12-month SaaS subscription, the customer has access to and uses the software for all 12 months.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This approach ensures that the revenue you&#8217;re reporting matches up with <em>when<\/em> you&#8217;re actually providing the service. It gives you a much clearer and more accurate picture of how your business is truly performing over time, rather than making it look like you earned a huge lump sum of cash all at once (which isn&#8217;t really the case if you&#8217;re providing an ongoing service!).<\/p>\n\n\n\n<p class=\"cnvs-block-core-paragraph-1751290415466 wp-block-paragraph\"><strong>Helpful tip: Synder Sync automates the initial capture of contract data<\/strong>. By integrating with your sales platforms (like Stripe or Square), it automatically brings transaction details, customer information, and sales amounts directly into your accounting system. It takes the hassle out of manually logging every new contract and makes sure the key details for revenue recognition are accurate and ready to go from day one. You&#8217;ll have a digital record of every sale, which serves as your &#8220;contract&#8221; source data. Additionally, QuickBooks offers a revenue recognition module, particularly within QuickBooks Online Advanced, which can automate the tracking and entry of deferred revenue. This helps businesses accurately recognize revenue over time without manual spreadsheet work, ensuring compliance with accounting standards and providing a clearer financial picture.<\/p>\n\n\n\n<h3 id=\"2-set-up-your-spreadsheet\" class=\"wp-block-heading\"><strong>2. Set up your spreadsheet&nbsp;<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Now, let&#8217;s dive into setting up your spreadsheet. You&#8217;ll need to design your <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1qVx9WurHLYikRGOo3KQMdoLjW1GvIjPbwqZdHCvPVo4\/edit?gid=650681962#gid=650681962\">Excel sheet<\/a> with a clear, logical structure to house all the essential data.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Start your sheet with columns to capture the most important information for each performance obligation. Let&#8217;s look at this data in columns A through H:<\/p>\n\n\n\n<figure class=\"wp-block-gallery aligncenter has-nested-images columns-default is-cropped wp-block-gallery-16 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1.png\"><img decoding=\"async\" width=\"1024\" height=\"193\" data-id=\"29711\" src=\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-1024x193.png\" alt=\"Excel sheet\" class=\"wp-image-29711\" srcset=\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-1024x193.png 1024w, https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-768x145.png 768w, https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-380x72.png 380w, https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-800x151.png 800w, https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-1160x219.png 1160w, https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1.png 1388w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Starting from the next available column (e.g., Column I), create a column for each month for the foreseeable future (e.g., 12-24 months or more, covering all your active contracts).<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Row 1 (Headers):<\/strong> Enter the start date of each month as the column header (e.g., 2025-03-01 etc.). Format these cells to display as MMM YYYY (e.g., &#8220;Mar 2025&#8221;).<\/li>\n<\/ul>\n\n\n\n<h3 id=\"3-implement-formulas-for-revenue-recognition\" class=\"wp-block-heading\"><strong>3. Implement formulas for revenue recognition<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Now, we get to the heart of your waterfall: figuring out exactly how much revenue from each obligation to recognize each month.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To ensure accuracy, especially since contracts don&#8217;t always start on the first of the month, we recommend using the daily ratable method,<strong> <\/strong>which is<strong> <\/strong>a way to spread out revenue recognition for a service or subscription evenly, day by day, over the exact duration of the contract.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Instead of recognizing a lump sum of revenue each month, it calculates a daily rate (Total Contract Value \/ Total Days in Contract). Then, for each month, you recognize revenue by multiplying that daily rate by the <em>actual number of days<\/em> the service was active within that specific month.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, let\u2019s see <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1qVx9WurHLYikRGOo3KQMdoLjW1GvIjPbwqZdHCvPVo4\/edit?gid=650681962#gid=650681962\">how it looks in practice.<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the first monthly column cell in your Excel spreadsheet (e.g., I2 for March 2025 revenue for the first contract), enter the following formula:<br><\/p>\n\n\n\n<figure class=\"wp-block-table cnvs-block-core-table-1751291727377\"><table class=\"has-gray-200-background-color has-background has-fixed-layout\"><tbody><tr><td>=IF(AND($C2&lt;=EOMONTH(I$1,0),$D2&gt;=I$1),(MIN(EOMONTH(I$1,0),$D2)-MAX(I$1,$C2)+1)*$G2,0)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br><strong>Explanation of the formula components:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>I$1:<\/strong> Refers to the first day of the month for the current column (e.g., March 1, 2025). The $ locks the row, allowing you to drag horizontally.<\/li>\n\n\n\n<li><strong>$C2:<\/strong> The Start Date of the performance obligation. The $ locks the column, allowing you to drag vertically.<\/li>\n\n\n\n<li><strong>$D2:<\/strong> The End Date of the performance obligation.<\/li>\n\n\n\n<li><strong>$G2:<\/strong> The Daily Rate of revenue recognition.<\/li>\n\n\n\n<li><strong>EOMONTH(I$1,0):<\/strong> Returns the last day of the month of the current column (e.g., 2025-03-31). This helps define the end of the recognition month.<\/li>\n\n\n\n<li><strong>AND(C2&lt;=EOMONTH(I1,0),D2&gt;=I1)<\/strong>: This is the core condition that checks for any overlap between the contract&#8217;s period and the current recognition month.<\/li>\n\n\n\n<li><strong>$C2&lt;=EOMONTH(I$1,0)<\/strong>: Ensures the contract&#8217;s start date is on or before the end of the current month.<\/li>\n\n\n\n<li><strong>$D2&gt;=I$1<\/strong>: Ensures the contract&#8217;s end date is on or after the beginning of the current month.<\/li>\n\n\n\n<li>If both conditions are true, there is an overlap, and the formula proceeds to calculate revenue for the overlapping days. If there&#8217;s no overlap, the formula returns 0.<\/li>\n\n\n\n<li><strong>MIN(EOMONTH(I$1,0),$D2):<\/strong> Determines the actual end date of the recognition period within the current month. It picks the earlier of the month&#8217;s last day (EOMONTH(I$1,0)) or the contract&#8217;s end date ($D2). This caps recognition at the contract&#8217;s end.<\/li>\n\n\n\n<li><strong>MAX(I$1,$C2)<\/strong>: Determines the actual start date of the recognition period within the current month. It picks the later of the month&#8217;s first day (I$1) or the contract&#8217;s start date ($C2). This ensures recognition only starts from the contract&#8217;s actual beginning.<\/li>\n\n\n\n<li><strong>(&#8230;) &#8211; (&#8230;) + 1:<\/strong> Calculates the number of days between the determined start and end dates within the overlapping period. Adding +1 includes both the start and end days.<\/li>\n\n\n\n<li><strong>* $G2:<\/strong> Multiplies the calculated number of days by the Daily Rate to determine the total revenue recognized for that specific month.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Apply the formula:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Then, drag the formula down for all other contracts\/obligations you&#8217;ve listed.<\/li>\n\n\n\n<li>Drag the formula across all the monthly columns for the first contract\/obligation.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-gallery aligncenter has-nested-images columns-default is-cropped wp-block-gallery-17 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-1.png\"><img decoding=\"async\" width=\"1024\" height=\"113\" data-id=\"29719\" src=\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-1-1024x113.png\" alt=\"Excel sheet\" class=\"wp-image-29719\" srcset=\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-1-1024x113.png 1024w, https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-1-768x84.png 768w, https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-1-1536x169.png 1536w, https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-1-380x42.png 380w, https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-1-800x88.png 800w, https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-1-1160x128.png 1160w, https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/excel-table-1-1.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1qVx9WurHLYikRGOo3KQMdoLjW1GvIjPbwqZdHCvPVo4\/edit?gid=650681962#gid=650681962\">Click here<\/a> to view the<strong> Excel spreadsheet template<\/strong> and explore the formulas in action.<\/p>\n\n\n\n<h3 id=\"4-create-summary-rows-and-columns\" class=\"wp-block-heading\"><strong>4. Create summary rows and columns<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">These summary sections are incredibly important. They give you instant insights into your total recognized revenue and help you keep a close eye on your deferred revenue balance.&nbsp;<\/p>\n\n\n\n<h4 id=\"total-recognized-revenue-per-month\" class=\"wp-block-heading\"><strong>Total recognized revenue per month:<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add a new row at the bottom of your waterfall (e.g., Row 100).<\/li>\n\n\n\n<li>In each monthly column, use a SUM formula to add up all the recognized revenue amounts for that specific month: =SUM(I2:I99). Drag this across.<\/li>\n\n\n\n<li>Record the resulting totals in your accounting system for each period.<\/li>\n<\/ul>\n\n\n\n<h4 id=\"total-recognized-per-contract-optional-for-verification\" class=\"wp-block-heading\"><strong>Total recognized per contract (optional, for verification):<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add a new column after your last monthly column (e.g., Column AZ).<\/li>\n\n\n\n<li>In this column, sum up the total recognized revenue for each individual contract\/obligation: =SUM(I2:AY2) (adjust range to your last month).<\/li>\n\n\n\n<li>Verify: The value in this column for each row should ideally equal the Total Value to Recognize (Column E) for that same row, indicating all revenue has been properly allocated and scheduled.<\/li>\n<\/ul>\n\n\n\n<h4 id=\"deferred-revenue-balance-needed-for-balance-sheet-reconciliation\" class=\"wp-block-heading\"><strong>Deferred revenue balance (needed for balance sheet reconciliation):<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Track it in a separate section of your schedule or a linked summary tab.<\/li>\n\n\n\n<li>Identify the starting Deferred Revenue Balance (Beginning of Period).<\/li>\n\n\n\n<li>Create a row for New Deferred Revenue Bookings.<\/li>\n\n\n\n<li>Create a row for Total Monthly Recognized Revenue (linked directly from the summary row calculated above).<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Formula for the end-of-month deferred revenue:<\/strong>&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table cnvs-block-core-table-1751291865519\"><table class=\"has-gray-200-background-color has-background has-fixed-layout\"><tbody><tr><td>Deferred Revenue (End of Month) = Deferred Revenue (Beginning of Month) + New Deferred Revenue Bookings &#8211; Total Monthly Recognized Revenue<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe src=\"https:\/\/www.youtube.com\/embed\/WHTbnwKNmaQ\" referrerpolicy=\"strict-origin-when-cross-origin\" title=\"How to Reconcile Deferred Revenue in QuickBooks | Revenue Recognition Tutorial with Synder\" width=\"1200\" height=\"675\" style=\"max-width: 100%; max-height: 284px;\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/iframe>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">By carrying this balance forward month-to-month, you&#8217;ll have an accurate, real-time reflection of your deferred revenue liability.<\/p>\n\n\n\n<h3 id=\"5-post-manual-journal-entries\" class=\"wp-block-heading\"><strong>5. Post manual journal entries<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This is where all your hard work on the spreadsheet comes to life in your accounting system (like QuickBooks Online or Xero). It&#8217;s how you officially record the revenue you&#8217;ve earned.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You&#8217;ll typically make<strong> <\/strong>two types of journal entries.<\/p>\n\n\n\n<h4 id=\"initial-entry-when-cash-is-received-invoice-issued\" class=\"wp-block-heading\"><strong>Initial entry (when cash is received \/ invoice issued)<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">This entry is recorded right when your customer pays you (or when you issue the invoice and have the right to get paid). At this point, you&#8217;ve received the money, but you haven&#8217;t delivered all the services yet, so it&#8217;s not yet earned revenue.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The accounting impact:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Debit: <\/strong>Bank account\/accounts receivable (This increases your cash in the bank or records that a customer owes you money.)<\/li>\n\n\n\n<li><strong>Credit: <\/strong>Deferred revenue (This increases a liability account called &#8220;Deferred Revenue.&#8221; Think of it as a promise to your customer: you owe them the service, so it&#8217;s a liability until you&#8217;ve delivered it.)<\/li>\n<\/ul>\n\n\n\n<h4 id=\"periodic-e-g-monthly-revenue-recognition-entry\" class=\"wp-block-heading\"><strong>Periodic (e.g., monthly) revenue recognition entry<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">This is the main event! At the end of each accounting period (usually monthly), you&#8217;ll use your waterfall schedule to tell your accounting system exactly how much revenue you <em>did<\/em> earn during that period.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Look at the &#8220;Total Recognized Revenue per Month&#8221; row you created in your waterfall schedule. This row is your single source of truth for the amount to recognize.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The accounting impact:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Debit: <\/strong>Deferred revenue (You&#8217;re reducing that &#8220;promise&#8221; liability, because you&#8217;ve now delivered a portion of the service. This moves the money <em>out<\/em> of the unearned bucket.)<\/li>\n\n\n\n<li><strong>Credit: <\/strong>Sales revenue (Or whatever specific income account you use for your core services. This is where you actually record the revenue you&#8217;ve earned in that period, increasing your income.)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">By diligently following these steps, you can create and maintain a compliant and accurate manual revenue recognition schedule, even for lower transaction volumes, ensuring your financial statements reflect earned revenue correctly.<\/p>\n\n\n\n<h2 id=\"final-thoughts\" class=\"wp-block-heading\"><strong>Final thoughts<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">With this guide, even small businesses handling more transactions can tackle revenue recognition without feeling overwhelmed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">By carefully keeping tabs on your promises (those performance obligations) and using a simple spreadsheet, you&#8217;ll make sure your books truly show the money you&#8217;ve actually earned, not just when cash landed in your bank account. This smart way of doing things not only helps you stay compliant with important accounting rules like GAAP and IFRS 15, but it also gives you a much clearer look into how well your business is <em>really<\/em> doing, setting you up for growth.&nbsp;<\/p>\n\n\n\n<p class=\"has-background wp-block-paragraph\" style=\"background-color:#d2e6fd\">Before you go: when your subscription volume grows and manual tracking becomes more of a burden than a process, it might be time to upgrade. <a href=\"https:\/\/synder.com\/industry\/revenue-recognition\/\"><strong>Synder RevRec<\/strong><\/a> is built to handle high-volume subscriptions and complex recognition scenarios with ease. For Stripe\u2013QuickBooks Online users, it offers a direct connection, syncing transaction data automatically and applying your recognition rules in real time. For all other platform combinations, you can easily import your data via Excel. Either way, Synder RevRec helps you generate audit-ready schedules, stay compliant, and save hours, so you can focus on growing your business.<\/p>\n\n\n\n<p class=\"has-text-align-center has-gray-200-background-color has-background cnvs-block-core-paragraph-1751985267107 wp-block-paragraph\" style=\"font-size:20px\"><strong>Curious what Synder RevRec can do for you? Schedule a call with our experts and find out!<\/strong><\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-fe48e5de wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-text-align-center wp-element-button\" href=\"https:\/\/sales.synder.com\/meetings\/synder\/revrec-discovery-call-article\" style=\"border-radius:50px\">Book a call<\/a><\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"Your business might not need full-scale revenue recognition automation just yet, but that doesn\u2019t mean compliance has to&hellip;\n","protected":false},"author":2308,"featured_media":29727,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"csco_singular_sidebar":"","csco_page_header_type":"","csco_page_load_nextpost":"","csco_post_video_location":[],"csco_post_video_url":"","csco_post_video_bg_start_time":0,"csco_post_video_bg_end_time":0,"footnotes":"","_ppma_block_editor_authors":""},"categories":[43,45,326],"tags":[255],"ppma_author":[396],"class_list":["post-29710","post","type-post","status-publish","format-standard","has-post-thumbnail","category-accounting","category-business-management","category-how-to-do-your-accounting","tag-business-owner","cs-entry","cs-video-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>The Ultimate Manual for Revenue Recognition<\/title>\n<meta name=\"description\" content=\"Manually track revenue recognition for your small business using simple Excel spreadsheets.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Ultimate Manual for Revenue Recognition\" \/>\n<meta property=\"og:description\" content=\"Manually track revenue recognition for your small business using simple Excel spreadsheets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/\" \/>\n<meta property=\"og:site_name\" content=\"Synder blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SynderHQ\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-30T14:25:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-26T12:43:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/banners-for-blog-94.png\" \/>\n\t<meta property=\"og:image:width\" content=\"4416\" \/>\n\t<meta property=\"og:image:height\" content=\"1386\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Hanna Danielak\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hanna Danielak\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Ultimate Manual for Revenue Recognition","description":"Manually track revenue recognition for your small business using simple Excel spreadsheets.","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:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/","og_locale":"en_US","og_type":"article","og_title":"The Ultimate Manual for Revenue Recognition","og_description":"Manually track revenue recognition for your small business using simple Excel spreadsheets.","og_url":"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/","og_site_name":"Synder blog","article_publisher":"https:\/\/www.facebook.com\/SynderHQ\/","article_published_time":"2025-06-30T14:25:57+00:00","article_modified_time":"2026-01-26T12:43:14+00:00","og_image":[{"width":4416,"height":1386,"url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/banners-for-blog-94.png","type":"image\/png"}],"author":"Hanna Danielak","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Hanna Danielak","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/#article","isPartOf":{"@id":"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/"},"author":{"name":"Hanna Danielak","@id":"https:\/\/synder.com\/blog\/#\/schema\/person\/11f9607eda0e1c4f5a3a9d927b5bf7b4"},"headline":"The Ultimate Guide to Manual Revenue Recognition","datePublished":"2025-06-30T14:25:57+00:00","dateModified":"2026-01-26T12:43:14+00:00","mainEntityOfPage":{"@id":"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/"},"wordCount":2680,"commentCount":0,"publisher":{"@id":"https:\/\/synder.com\/blog\/#organization"},"image":{"@id":"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/#primaryimage"},"thumbnailUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/banners-for-blog-94.png","keywords":["Business Owner"],"articleSection":["Accounting","Business","How to Do Your Accounting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/","url":"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/","name":"The Ultimate Manual for Revenue Recognition","isPartOf":{"@id":"https:\/\/synder.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/#primaryimage"},"image":{"@id":"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/#primaryimage"},"thumbnailUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/banners-for-blog-94.png","datePublished":"2025-06-30T14:25:57+00:00","dateModified":"2026-01-26T12:43:14+00:00","description":"Manually track revenue recognition for your small business using simple Excel spreadsheets.","breadcrumb":{"@id":"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/#primaryimage","url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/banners-for-blog-94.png","contentUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2025\/06\/banners-for-blog-94.png","width":4416,"height":1386,"caption":"The Ultimate Guide to Manual Revenue Recognition"},{"@type":"BreadcrumbList","@id":"https:\/\/synder.com\/blog\/the-ultimate-guide-to-manual-revenue-recognition\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/synder.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Business","item":"https:\/\/synder.com\/blog\/category\/business-management\/"},{"@type":"ListItem","position":3,"name":"The Ultimate Guide to Manual Revenue Recognition"}]},{"@type":"WebSite","@id":"https:\/\/synder.com\/blog\/#website","url":"https:\/\/synder.com\/blog\/","name":"Synder blog","description":"Business Hacks &amp; Accounting Automation Use Cases","publisher":{"@id":"https:\/\/synder.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/synder.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/synder.com\/blog\/#organization","name":"Synder","url":"https:\/\/synder.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/LOG.svg","contentUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/LOG.svg","width":303,"height":332,"caption":"Synder"},"image":{"@id":"https:\/\/synder.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SynderHQ\/"]},{"@type":"Person","@id":"https:\/\/synder.com\/blog\/#\/schema\/person\/11f9607eda0e1c4f5a3a9d927b5bf7b4","name":"Hanna Danielak","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/10\/Hanna-Danielak-Synder-110x110.jpgd8adde4c1d250a7a09ed50cf66d23645","url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/10\/Hanna-Danielak-Synder-110x110.jpg","contentUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/10\/Hanna-Danielak-Synder-110x110.jpg","caption":"Hanna Danielak"},"description":"Hanna works at Synder as an interviewer and client story researcher, where she connects directly with accountants, CFOs, and business owners to uncover insights about their financial workflows. She has deep conversations with Synder users, gathering feedback on how they use accounting automation and turning it into content that speaks to what the industry actually cares about. This unique position allows Hanna to create informative success stories and influence product improvements based on real user experiences.","sameAs":["https:\/\/www.linkedin.com\/in\/hanna-danielak-b23178159\/"],"url":"https:\/\/synder.com\/blog\/author\/hannadanielak\/"}]}},"authors":[{"term_id":396,"user_id":2308,"is_guest":0,"slug":"hannadanielak","display_name":"Hanna Danielak","avatar_url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/10\/Hanna-Danielak-Synder-110x110.jpg","author_category":"","first_name":"Hanna","last_name":"Danielak","user_url":"","job_title":"","description":"Hanna Danielak is a Copywriter and Interviewer at Synder, an AICPA startup program alum. With a strong background in PR and media marketing, she dives deep into fintech and ecommerce, crafting top-notch content for blogs, websites, and forums. At Synder, Hanna brings stories to life by interviewing accounting pros and business owners, transforming their journeys and achievements into captivating success stories that truly resonate and highlight their unique journeys and industry expertise."}],"_links":{"self":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts\/29710","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/users\/2308"}],"replies":[{"embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/comments?post=29710"}],"version-history":[{"count":25,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts\/29710\/revisions"}],"predecessor-version":[{"id":31263,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts\/29710\/revisions\/31263"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/media\/29727"}],"wp:attachment":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/media?parent=29710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/categories?post=29710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/tags?post=29710"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=29710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}