Finance | Project Operations, Human Resources, ...

how to get G/L transaction list for a certain period

(0) Share

Report

Posted on by Kelly6192007

Hi Guys,

Glad there is a community here. i am new to D365, trying to do bank recon, want to check which payment have been posted,how can i get the transaction list within a period for particular ledger account?

Thanks for your help in advance.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

saurabh bharti 15,037 Moderator on at

Like (0)

Report

RE: how to get G/L transaction list for a certain period

In addition to others :

If you want to reconcile ledger and bank sub ledger

1. Cash and Bank > Bank Accounts > Select Bank account > On to click on Transactions

2. Extract transactions in Excel (By clicking Office button on top right corner) : You can apply filter on date column and make sure you have voucher reference

3. General ledger > Inquiries > Voucher transactions > Filter Main account mapped to Bank subledger and give date range (1/10/2021..31/10/2021)

or you can directly click ok and the apply these filters

4. Add Posting type to the screen and extract data in excel

5. Now you can compare data from step 2 and 4 based on voucher number for reconciliation

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,612 Super User 2025 Season 2 on at

Like (0)

Report

RE: how to get G/L transaction list for a certain period

Hi Kelly,

There are several standard reports that you can use for this purpose that are already mentioned:

1- Voucher transaction - You can apply additional filter (e.g. date and account)

2- Trial balance - You can apply filter for financial dimension set

3- Ledger transaction list

You can export this report to Excel via Excel add-inn og export function on reports.

Was this reply helpful? Yes No
Suggested answer

Gaurangkumar Jani 4,512 User Group Leader on at

Like (0)

Report

RE: how to get G/L transaction list for a certain period

Hi Kelly,

You can open the GL transaction from the trial balance and put any of the following filters:

1. "Date": Transaction date

2. "Period Name" - Add this column

3. "Period Start" - Add this column

I hope this will help you.

Thanks,

Was this reply helpful? Yes No
André Arnaud de Cal... 298,020 Super User 2025 Season 2 on at

Like (0)

Report

RE: how to get G/L transaction list for a certain period

HI Kelly,

If you need the detailed transactions, you can go to the Voucher transactions form and set your ranges for the period and the main accounts.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: how to get G/L transaction list for a certain period

Hi,

Have you used the trial balance site for that, which is available in the GL inquiries section?

Best regards,

Ludwig

Was this reply helpful? Yes No