My husband started a little business. I want to begin spreadsheets to keep track of customers, jobs, invoices, expenses, and income. I started a couple but I'm sure there is a better way since they are a little overwhelming with the number of columns. Do you have any tips or hints on how to organize everything best?

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

Use an actual accounting/business financial management tool like QuickBooks

like

Came here to say the same thing.

There are a few excel templates that might be of help! Sorry not the most excel genius answer but they can be helpful to start out..

What kind of business?

You could try using Chat GPT to make something like that for you. I have heard people say you can do that but have never actually tried it myself. There are also some great templates in Excel that might fit your needs.

Please don’t call it a little business

Related Posts

Bain & Company Hey! Got dinged at BCG and Mck and then hadn't heard back from Bain, but just found out I made it to final rounds. I haven't been prepping for over a week as it'd be two since my first round at Bain.

Help! Whats different or similar about Bain final rounds? I'm applying to Texas offices for an experienced AC role. I also may have to have an accelerated final round as I'm leaving the country for most of April. Bain & Company

like

Hey! Can anyone recommend me a good facialist in downtown/brickell?

like

What SAP LAB provides in welcome kit for associate consultants ??

like

Hi Fishes,

I got interviewed at infosys two days back.
When can I expect to hear back from them.
Also all the questions that were asked to me were written coding questions(Write block of code) none were verbal.I could write all answers but none was 100% correct.

At last I asked the interviewer about feedback as in where was I wrong. He said at couple of places and he explained me where was I wrong.

Do you all think I will be rejected?

like

Hi Fishes,

I am B.tech graduate and currently working in BPO sector in Accenture. I am looking to switch to an IT profile but having zero experience in IT sector. Please suggest how can I switch.

Hi fishes, Need info about Infosys Consulting bridge. Do we get to choose which practice we can join? Also is the process easy and worth it? What increase in pay can we expect? Infosys

like

Hi Fishes,
My wife got the Visa however with the visa envelope she didnt recieve the BRP letter collection for UK.
What can be done here ?How can she travel ?

like

This Indian matchmaking show is interesting...love how the first girl is like “my partner needs to fit in my life” 😳🙄😳🙄🤭

likefunnyhelpful

Do managers tend to make a scene while you put your papers?

I have received offer from accenture but still I am not accept it as my current company's increment letter is due. Is they consider my increment letter and send me the revised offer letter if I accept it now???? Please help me.

like

Anyone buy les mills bodypump for at home? I started going to classes pre-COVID and really loved it. Curious about the at home experience. OR any experience with Beachbody Lift4 program?

like

I have an interview with IKEA for Azure DE/ Devops role. Kindly share sample questions and experience?

like

Hello Everyone,

I have a query . I want to know about the projects in Impetus, Clairvoyant and Affine company. How are the projects. Is it pre-developed or we get from scratch?

#hiring #bigdata engineers with 2-7 years experience on Hadoop, hive, spark, SQL, java or python.

If interested please connect to me.

like

I have my second round of interview for consultant role with mastercard data and services. Can anyone here help explain the kind of projects the team does, and also how your interview experiences have been? Thank you!

Hi fishes , Just want to check when relocation amount paid off , and do we need to produce bills ?

What I heard is it's lumsum amount.

like

Is relocating to Pune mandatory? Do they allow to work from Mumbai office?

Hi Fishes,

Are there any updates to physically return to Banglore office for work? Is June a hard deadline to join the office?

like

Interviewing for a Senior Specialist role in Product Management (Commercial, Smart Data). Could someone please provide insight on what I can expect in the interview process as well as the role and overall culture/wlb? Expected comp? It’s onsite at the Arlington office but curious about hybrid accommodations. Thanks!

Wonder what the discrepancy in salary was between these sexual predators and their prey... #timesup

Post Photo
like

Additional Posts in Excel Genius

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

How long did it take you to become good at excel? Like fast?

like

How do I compare two sheets to make sure they are identical?

like

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

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

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

like

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

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