---
id: video/W3xWt6j4-Ms
type: video
title: Comparing Financial Reporting Tools Between Dynamics GP and Dynamics Business Central (2024)
summary: Account schedules in Business Central as the replacement for GP financial reporting. Covers the eight built-in schedules, account categories carried over by the GP cloud migration tool, row formulas, column layouts, dimension filtering, drill-down, and Excel export and cross-company import.
tier: official
language: en
tags:
  - account schedules
  - financial reporting
  - account categories
  - account subcategories
  - chart of accounts
  - gp migration
  - dimension filtering
  - excel export
system: finance
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:06:40.749Z"
  flags: []
generated:
  at: "2026-10-13T00:32:41.360Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 5ff9865526aed2e2713541a813a4987bb6ceb427e3437c2f33db71c4137f4d9b
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=38s
    title: Comparing Financial Reporting Tools Between Dynamics GP and Dynamics Business Central (2024)
    date: "2024-08-26T13:49:39.000Z"
    commit: null
    t: 38
    quote: business Central comes with eight different account schedules out of the box
  - kind: video
    url: https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=64s
    title: Comparing Financial Reporting Tools Between Dynamics GP and Dynamics Business Central (2024)
    date: "2024-08-26T13:49:39.000Z"
    commit: null
    t: 64
    quote: if you use the cloud migration tool to migrate your data from GP to business Central then your accounts and the categories assigned will
  - kind: video
    url: https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=91s
    title: Comparing Financial Reporting Tools Between Dynamics GP and Dynamics Business Central (2024)
    date: "2024-08-26T13:49:39.000Z"
    commit: null
    t: 91
    quote: I can also see any accounts in my chart of accounts that are not currently assigned a category and therefore will not be included
  - kind: video
    url: https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=158s
    title: Comparing Financial Reporting Tools Between Dynamics GP and Dynamics Business Central (2024)
    date: "2024-08-26T13:49:39.000Z"
    commit: null
    t: 158
    quote: each row is numbered so that you can create formulas allowing you to sum up mult multiple accounts or multiple divide values
  - kind: video
    url: https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=212s
    title: Comparing Financial Reporting Tools Between Dynamics GP and Dynamics Business Central (2024)
    date: "2024-08-26T13:49:39.000Z"
    commit: null
    t: 212
    quote: you can also filter account schedules by dimensions in this example let's say we want to filter on our sales department
  - kind: video
    url: https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=238s
    title: Comparing Financial Reporting Tools Between Dynamics GP and Dynamics Business Central (2024)
    date: "2024-08-26T13:49:39.000Z"
    commit: null
    t: 238
    quote: each accounts schedule can also be exported to excel in addition if you create account schedules and want to use it in other companies
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: W3xWt6j4-Ms
channel: yt-microsoft
source_name: Microsoft Dynamics 365 Business Central (YouTube)
url: https://www.youtube.com/watch?v=W3xWt6j4-Ms
published_at: "2024-08-26T13:49:39.000Z"
duration_s: 271
captions: full
audience:
  - functional consultant
  - administrator
  - end user
chapters:
  - t: 0
    title: Financial reporting in GP and introduction to Business Central
  - t: 38
    title: Account schedules overview and built-in templates
  - t: 64
    title: Account categories and migration from GP
  - t: 121
    title: Creating and updating account categories
  - t: 158
    title: Account schedule structure, formulas and column layouts
  - t: 212
    title: Filtering by dimensions and drilling down into details
  - t: 238
    title: Exporting and importing account schedules
features:
  - name: Account Schedules
    status: unclear
    t: 38
    verified: false
    status_source: video
  - name: Account Categories and Subcategories
    status: unclear
    t: 64
    verified: false
    status_source: video
  - name: Account Schedule Row Definitions and Formulas
    status: unclear
    t: 158
    verified: false
    status_source: video
  - name: Account Schedule Column Layouts
    status: unclear
    t: 178
    verified: false
    status_source: video
  - name: Dimension Filtering for Account Schedules
    status: unclear
    t: 212
    verified: false
    status_source: video
  - name: Drill Down into Account Schedule Details
    status: unclear
    t: 223
    verified: false
    status_source: video
  - name: Account Schedule Export to Excel
    status: unclear
    t: 238
    verified: false
    status_source: video
  - name: Account Schedule Import and Export Across Companies
    status: unclear
    t: 253
    verified: false
    status_source: video
objects_mentioned: []
quotes:
  - t: 38
    text: business Central comes with eight different account schedules out of the box
    check: exact
  - t: 64
    text: if you use the cloud migration tool to migrate your data from GP to business Central then your accounts and the categories assigned will
    check: exact
  - t: 91
    text: I can also see any accounts in my chart of accounts that are not currently assigned a category and therefore will not be included
    check: exact
  - t: 158
    text: each row is numbered so that you can create formulas allowing you to sum up mult multiple accounts or multiple divide values
    check: exact
  - t: 212
    text: you can also filter account schedules by dimensions in this example let's say we want to filter on our sales department
    check: exact
  - t: 238
    text: each accounts schedule can also be exported to excel in addition if you create account schedules and want to use it in other companies
    check: exact
---

# Comparing Financial Reporting Tools Between Dynamics GP and Dynamics Business Central (2024)

> Account schedules in Business Central as the replacement for GP financial reporting. Covers the eight built-in schedules, account categories carried over by the GP cloud migration tool, row formulas, column layouts, dimension filtering, drill-down, and Excel export and cross-company import.

[Watch on YouTube](https://www.youtube.com/watch?v=W3xWt6j4-Ms) · Microsoft Dynamics 365 Business Central (YouTube) · 2024-08-26 · 4:31 · tier official · reviewed (checked by Opus)

## Overview

A 5-minute demo from August 2024 for GP users moving to Business Central. It shows how financial statements are built with account schedules, which use account subcategories from general ledger accounts. Business Central includes eight account schedules out of the box.

The demo covers how accounts and their categories come across with the cloud migration tool, and how to create categories for accounts that were not assigned one. It then goes through row numbering and formulas, column layouts and date ranges, filtering by dimension (a sales department example), drilling down into amounts, and exporting schedules to Excel or to other companies.

## Key points

- Business Central ships with eight account schedules out of the box.
- Account schedules build financial statements from account subcategories assigned to general ledger accounts.
- Accounts without an assigned category are not included on account schedules; the chart of accounts shows which ones are unassigned.
- With the cloud migration tool from GP, accounts and their assigned categories are moved to Business Central.
- After creating or changing account categories, update the account schedules so new accounts appear.
- Each row is numbered so formulas can sum multiple accounts or divide values; bold, italics and page breaks are available.
- Schedules can be filtered by dimension, drilled down into amounts, exported to Excel, and exported and imported between companies.

## Chapters

- [0:00](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=0s) Financial reporting in GP and introduction to Business Central
- [0:38](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=38s) Account schedules overview and built-in templates
- [1:04](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=64s) Account categories and migration from GP
- [2:01](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=121s) Creating and updating account categories
- [2:38](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=158s) Account schedule structure, formulas and column layouts
- [3:32](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=212s) Filtering by dimensions and drilling down into details
- [3:58](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=238s) Exporting and importing account schedules

## Features

Every feature below: status not stated, demoed.

| Feature | At |
|---|---|
| Account Schedules | [0:38](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=38s) |
| Account Categories and Subcategories | [1:04](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=64s) |
| Account Schedule Row Definitions and Formulas | [2:38](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=158s) |
| Account Schedule Column Layouts | [2:58](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=178s) |
| Dimension Filtering for Account Schedules | [3:32](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=212s) |
| Drill Down into Account Schedule Details | [3:43](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=223s) |
| Account Schedule Export to Excel | [3:58](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=238s) |
| Account Schedule Import and Export Across Companies | [4:13](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=253s) |

## Quotes

- [0:38](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=38s) "business Central comes with eight different account schedules out of the box"
- [1:04](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=64s) "if you use the cloud migration tool to migrate your data from GP to business Central then your accounts and the categories assigned will"
- [1:31](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=91s) "I can also see any accounts in my chart of accounts that are not currently assigned a category and therefore will not be included"
- [2:38](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=158s) "each row is numbered so that you can create formulas allowing you to sum up mult multiple accounts or multiple divide values"
- [3:32](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=212s) "you can also filter account schedules by dimensions in this example let's say we want to filter on our sales department"
- [3:58](https://www.youtube.com/watch?v=W3xWt6j4-Ms&t=238s) "each accounts schedule can also be exported to excel in addition if you create account schedules and want to use it in other companies"