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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Payment Journal No. Series vs Posting No. Series – how to match bank references?

(0) ShareShare
ReportReport
Posted on by

Hi all,

I’m looking for advice on how others manage No. Series vs Posting No. Series in Payment Journals in Dynamics 365 Business Central.

Currently, we have both No. Series and Posting No. Series set up on our payment journals.

Our process:

  • Payments are prepared in the payment journal
  • The No. Series is used as the reference when sending payments to the bank (this is what appears on the bank transaction)
  • The approver authorises the payment on bank and posts the journal at the same time

The issue we’re facing:

  • The posted transaction ends up with a different number (Posting No. Series) in Business Central
  • This means the reference in the bank statement (CSV import) does not match the posted transaction number in BC
  • While bank reconciliation itself still works, the mismatch makes tracing transactions more difficult and less intuitive

My question:
👉 How do you manage No. Series and Posting No. Series for payment journals so that the reference matches the bank transaction?

Some specific points I’d appreciate insight on:

  • Do you use the same No. Series for both fields?
  • Do you avoid Posting No. Series altogether for payments?
  • Do you rely on External Document No. instead for matching?
  • Any best practices for ensuring consistency between bank references and posted entries?

Thanks in advance for any tips or examples of how your team handles this! We’re trying to standardise our process, so both technical and practical workflow suggestions are welcome :)

I have the same question (0)
  • Suggested answer
    Teagen Boll Profile Picture
    1,728 Super User 2026 Season 1 on at
    I recommend not using the posting no. series on payment journals. It doesn't really provide value for bank references for cheque numbers or eft numbers.
     
    Here is why, below is a payment journal batch with no posting no. series:
    I have CHQ1 and CHQ2
     
    When I post it without a posting series it retains that number:
     
    That's how you should be preparing your payment journals and posting them if you need a backup reference. This is also important for the bank reconciliations you perform as the descriptions from a bank statement can match up against those document no.s
     
    So why does the posting no. series exist?
    It's not for payment journals with a specific reference to your internal documents (EFT, Checks etc.). The posting no. series is really just used when you have manual journal entries or want to use a specific sequence on posting. You may for example have 10 journal batches that multiple users are working in at the same time. They may have the same number series' for each of those. To ensure each entry is posted with a unique number and there is no overlap or data inconsistency you use the posting no. series. You may also get errors if you post out of sequence (i.e. I posted GJ002 and your batch still shows GJ001 so you get an error when posting)
     
    Best practices?
    Don't use a posting no. series for payment journals.
    If you are going to use a posting no. series, I usually recommend using it for manual entries OR I recommend creating no. series' for specific purposes and assigning each of the no. series' to a batch with a specific purpose (i.e. - Payroll, Month End, Accruals etc.)
     
    Hopefully that helps a bit,
    Teagen Boll, CPA
    Social: LinkedIn
  • Suggested answer
    Valentin Castravet Profile Picture
    32,341 Super User 2026 Season 1 on at
    Most people do not use a Posting No. Series for payments or journals in general, unless there is a specific reason to do so. Based on what you described, it does not sound like you need it.
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,711 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 998 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 635 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans