Course
|
Alteryx

Automating Financial Statement Preparation

Drastically cut down on time preparing financial statements by learning how to use Alteryx to automate financial statements. Learn how to automate the processing of Income Statements, Balance Sheets, and Cash Flow Statements.
4 HOURS
Advanced
12 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Automate Sales Revenue Ledger Updates
Prepare Trial Balances
Automate Income Statements
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Alteryx

Automating Financial Statement Preparation

Drastically cut down on time preparing financial statements by learning how to use Alteryx to automate financial statements. Learn how to automate the processing of Income Statements, Balance Sheets, and Cash Flow Statements.
4 HOURS
Advanced
12 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Automate Sales Revenue Ledger Updates
Prepare Trial Balances
Automate Income Statements
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

12 Lessons
Course Introduction
3 MINS
LESSON
Course Introduction
Exercise

In this lesson, we get a preview of the course ahead.

Automating Sales Revenue Ledger Updates
5 MINS
LESSON
Automating Sales Revenue Ledger Updates
Exercise

Learn how to consolidate sales revenue into a single account value.

Preparing a Trial Balance
5 MINS
LESSON
Preparing a Trial Balance
Exercise

Consolidate your accounts into a single file and ensure that the credit and debit fields match.

Preparing an Income Statement
5 MINS
LESSON
Preparing an Income Statement
Exercise

Extract data from a trial balance and prepare an income statement to determine net income.

Formatting an Income Statement
8 MINS
LESSON
Formatting an Income Statement
Exercise

Format your raw income statement data into a table that can be outputted in a pdf.

Preparing Balance Sheet Assets
8 MINS
LESSON
Preparing Balance Sheet Assets
Exercise

Use data from the trial balance to prepare the assets section of the income statement.

Finalizing the Balance Sheet
5 MINS
LESSON
Finalizing the Balance Sheet
Exercise

Use data from the trial balance and income statement to prepare the liabilities section of the income statement.

Formatting a Balance Sheet
9 MINS
LESSON
Formatting a Balance Sheet
Exercise

Format your balance sheet into a presentable table that can be saved as a pdf.

Preparing Cash Flow Operating Activities
9 MINS
LESSON
Preparing Cash Flow Operating Activities
Exercise

Use income statement and balance sheet data to prepare the operating activities section of a cash flow statement.

Finalizing the Cash Flow Statement
8 MINS
LESSON
Finalizing the Cash Flow Statement
Exercise

Add the investing and financing income sections of a cash flow and calculate net change in cash between 2 years.

Formatting Cash Flow
6 MINS
LESSON
Formatting Cash Flow
Exercise

Format a cash flow statement into presentable tables that can be saved as a pdf.

Course Overview
2 MINS
LESSON
Course Overview
Exercise

In this lesson, we summarize what we learned throughout this course.

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo