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?

(2) ShareShare
ReportReport
Posted on by 9

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,837 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,390 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.
     
  • Suggested answer
    YUN ZHU Profile Picture
    99,697 Super User 2026 Season 1 on at
    Can't you just use No. Series to manage it?
     
    Thanks.
    ZHU
  • Suggested answer
    Aman Kakkar Profile Picture
    3,180 Super User 2026 Season 1 on at
    As suggested by other experts, you can just remove the Posting No. Series from the batch and it should work for you.
  • Suggested answer
    OussamaSabbouh Profile Picture
    14,008 Super User 2026 Season 1 on at
    Hello,
    I’d keep it simple: for Payment Journals, use the same No. Series and Posting No. Series if you want the bank reference to match what gets posted in Business Central; otherwise you create the exact mismatch you described. A separate Posting No. Series is only worth it if you have a real audit/process reason for different posted numbering. External Document No. is useful as a backup searchable reference, but I wouldn’t use it as the main fix here. Also watch out for Renumber Document Numbers, because that can change the journal Document No. before posting and break consistency with the bank reference.
    Regards,
    Oussama Sabbouh

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,948 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,048 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 727 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans