web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How do we record opening balance for check for previous year which doesn't have invoices

(5) ShareShare
ReportReport
Posted on by 284
How do we record opening balance for check for previous year which doesn't have invoices
I have the same question (0)
  • Suggested answer
    Assisted by AI
    NAV_with_Narang Profile Picture
    2,384 Moderator on at

    If the opening balance is for a cheque from a previous year and there are no invoices tied to it, you don’t need to create any customer/vendor documents.

    To handle this in Business Central is:

    1. Post a General Journal entry as of the opening date
    2. Debit/Credit the Bank Account (where the cheque is held)
    3. Offset it to an Opening Balance / Suspense / Retained Earnings account (depending on how your opening balances are being handled)
    4. Add a clear description mentioning it’s an opening cheque balance

    If you need this to appear against a specific customer/vendor ledger:

    1. Use a Customer/Vendor General Journal instead of a regular one
    2. Post the entry to the customer/vendor account (no invoice needed)
    3. This will create an open ledger entry which can be applied later if required

    Key point: you’re not recreating history, just bringing the balance into BC as a starting point

  • Suggested answer
    OussamaSabbouh Profile Picture
    17,623 Super User 2026 Season 1 on at
    Hello,
    If the old check/payment has no invoice in Business Central, don’t try to apply it to an invoice that doesn’t exist; record it through a General Journal / Cash Receipt Journal / Payment Journal depending on whether it is customer receipt or vendor payment, using the real previous-year posting date if the period is open, otherwise use your opening balance date, and post it directly against the correct Customer/Vendor/Bank/G/L balancing account. If you need the customer/vendor to show an open balance, post the opening entry to the Customer/Vendor account; if it is only a bank opening balance item, post it to the Bank Account and the proper opening balance G/L account. Later, if the invoice or correction is created, you can apply/unapply entries from customer/vendor ledger entries.

    Oussama Sabbouh
  • Suggested answer
    AndrewThomas81 Profile Picture
    2,220 on at
    Process the cheque via the payment journal as normal, if it doesn't realte to any open items, don't apply it
     
    Andrew Thomas FCCA MCP
    YouTube - Use Business Central
    LinkedIn
     
  • Suggested answer
    Jainam M. Kothari Profile Picture
    17,024 Super User 2026 Season 1 on at
    Hello,
     
    You can record Customer and Vendor opening balances through General Journals by entering invoice-wise line details and setting the Document Type as “Invoice.” For Bank accounts, G/L accounts, and Fixed Assets, opening balances can also be posted using General Journals.

    For Item opening stock, you can use Item Journals to capture the initial inventory quantities and values.

  • Suggested answer
    RockwithNav Profile Picture
    9,191 Super User 2026 Season 1 on at

    You can simply record the bank’s opening balance unless you specifically need to maintain check ledger entries. Typically, I migrate the bank balance as an opening balance, which can be reconciled at any time. For new transactions use the check and have those entries.

  • Suggested answer
    YUN ZHU Profile Picture
    101,995 Super User 2026 Season 1 on at
    Hi, hope the following helps as well.
     
    Thanks.
    ZHU
  • Suggested answer
    Grigorios Mavrogeorgis Profile Picture
    2,514 Super User 2026 Season 1 on at
    Hi,
    For opening balance of cheques without invoice, the cleanest way is through the General Journal, not the Purchase journal.
     
    Create a line with Account Type Vendor (or Customer), the Account No., Document Type Payment, Document No. the original cheque number, and the amount. On the balancing side, use a temporary account like Opening Balance Equity or a Bank Suspense, depending what your accountant prefers for the migration. Post it
     
    After posting, the entry sits as an open Vendor Ledger Entry of type Payment, ready to be applied later when the matching invoice comes in, or left open if the cheque had no invoice behind it
     
    For cheques issued last year but not yet cleared, remember also to record them on the Bank Account Reconciliation as outstanding, otherwise the bank balance will not reconcile
     
    If the previous year is closed, check Allow Posting From and To on General Ledger Setup, this can block the entry. Either open the period for a moment or post on the first day of the new fiscal year and adjust the equity side after.
     
     Tick the checkbox below to mark the answer as verified, if it helped resolve your question.
     
    Regards
    Gregory Mavrogeorgis
     
     
     
     
     
     
  • Gerardo Rentería García Profile Picture
    27,261 Most Valuable Professional on at

    Hi, good day
    I hope this can help you, and give you some hints.

    remove old opening balance and enter new one?

    Best Regards
    Gerardo

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,050 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,441 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,175 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans