I am looking for some practice on building financial statements from scratch for a case study I have coming up. Does anyone know of a resource/tool that can generate raw data to manipulate into financial statements?

like
Posting as :
works at
You are currently posting as works at

Assuming you haven’t tried this yet, put that exact post into ChatGPT-4 and specify the output format you want the data in (fields and file type). You should get a lot of what you need from there.

like

Thank you. I will give that a try.

like

For raw financial statement data check out any public 10K/Q (quarterly or annual report). Edgar site allows for excel exports I believe excel download is public. if not open a pdf in excel.

like

Thank you for the insight but the trial balance data is exactly what I am looking for. The case study I am performing is on financial due diligence. I need to practice creating a data book based on client data provided. This data is typically the trial balance, sales by customers, salaries by management, etc. The trial balance data which has all of the “chart of accounts “ is needed to aggregate into the financial statement line captions.

For $30, Spreadsheet crafter has an excellent financial statement template that has been created and works without flaw. You just can change any of the formulas that has been built into it.

Thank you for that. I believe I wasn’t clear with what I was requesting. I am looking to build the financial statements from a company’s chart of accounts. For example, I want all of the revenues and directs costs that I could aggregate into the line item of gross profit on the income statement. I hope this helps.

Related Posts

Yoe 3.5 yrs , holding one offer 24.5, how much can i ask for, in JP Morgan chase HR round?

How much are you all spending on decor/flowers? I am in north jersey and want to spend no more than 4000, and wondering if that’s enough? Medium/tall centerpieces are 150+ and I’m trying to do some faux floral backdrops/arches myself

Post Photo
like

How do you start searching for mortgage loans and what do you look into lender

like

Did Epsilon just go through a round of layoffs ?

Wanted to highlight Prudential Financial’s hiring practices. They rescinded my offer once I attempted to negotiate the salary. The official reason given was that I didn’t “sound excited enough”.
They then admittedly gave the offer to someone who was less qualified. There were other red flags throughout the job offer process that the HR team should overall be ashamed of.

like

Guys I am on talent pool since last 3 months and I am worried now wrt my job security in the company. I see no open position for india geography in open careers page and not sure if I will get a project any sooner. Should I be worried? Anyone have any idea about globant firing employees on bench?

like

Anyone have recommendations for a dog trainer in Queens?

like

I’ve been using Apple Pay for the subway, and I saw a sign that said if you do 12 trips a week then you wouldn’t be charged after that. I’m being charged past 12 trips… is there something I need to do? Any tips would be helpful!

Impetus technologies inc can someone tell me hows the company is, i am having offer as lead engineer in sql . I am having 10 years of experience, should i join it?

like

Those who have moved from development into SE, do you have a desire to move into full sales or are you happy with SE and the career path it provides?

like

How do you deal with an HR that ghosts you after 3 interviews that went really well? I landed an offer at Deloitte as a sr. consultant, and then negotiated for a managerial role. I was told all interviewers were really happy with me so she would be glad to arrange a reevaluation for the new role(I was interviewed by 2 Sr. Managers & an MD for Sr. Consultant role and will have to take another round with a partner for the managerial position). I tried following up thrice after, no response.

like
like

Best companies for CX strategy and design?

like

Des infos sur eight advisory ? :)

Tops? Message me, I’m free this weekend lawlz

funny

I can't believe they still haven't caught the person who planted pipe bombs during the 1/6 attacks.

likefunny

Have an offer for Cognizant and Persistent Systems. Which one is a better company??

like

Got offer from Cognizant and Infosys.. Where Cognizant offering more package almost 1.5 Lpa mor, but heard lot of negative review on social media like they don't have good project, no job security, they will make you to work on other tech etc . Is it true ? Share some pro and cons that will be greate .. thnks

like

How much time it takes for BGV to complete in Optum? Mine is in progress from 45 days. Is it normal?

like

Juneteenth is just around the corner. This is the first year I get the day off as a company holiday -- not sure if my company is having any programs or events. How about yours? And if not, are you doing anything on your own to recognize/celebrate this day?

like

Additional Posts in Excel Genius

What are your top Excel ninja tricks? Ones that few people know...

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Still don't have xlookup. #fomo

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Anyone know what these badges are?

Post Photo
likefunny

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal