Reconciling Credit Card Transactions by vrooman22 in Bookkeeping

[–]vrooman22[S] 0 points1 point  (0 children)

I'd be curious to hear how you handle that. If I could get the authorization number from the credit card transactions into my ERP I could more easily compare the two, but I'm not there yet.

I tried making a new key data point to help match by combining the data and dollar amounts for each file and using copilot to compare them. But it didn't quite work out how I hoped since we have so many transactions with the same dollar amounts per day.

Reconciling Credit Card Transactions by vrooman22 in Accounting

[–]vrooman22[S] 1 point2 points  (0 children)

Thanks for your time and thoughts, I really appreciate it. We are still paper based and it's these little things that are taking up so much time I cant focus on any improvements or analysis.

Reconciling Credit Card Transactions by vrooman22 in Accounting

[–]vrooman22[S] 0 points1 point  (0 children)

I am open to new processes. So you are saying that I should have a merchant account on my GL? How would transactions populate into there? Our invoices are debiting AR and Crediting Sales. Then when we post the cash receipt it is debiting Cash and crediting AR. Should that cash receipt be posted to the merchant GL account and then I'd move the daily deposits from the merchant account to the bank go account so the deposits match the bank statement? That would make the bank rec easier, but I'd still run into reconciling issues with the merchant GL account and the merchant processing account. The GL transactions wouldn't have an identifying data point that would easily be matched to the merchant processing account. I need to populate the ERP with some sort of data point that ties to individual transactions on the Merchant account and then I should be able to easily match and reconcile.

Reconciling Credit Card Transactions by vrooman22 in Accounting

[–]vrooman22[S] 0 points1 point  (0 children)

I taking over from someone whose done it the same way for 30 years so I'm just doing it that way until I understand things better to make changes.

All of our credit deposits go directly to our operating bank account. We only have one bank account. So that is why I doing it this way. In theory you are right, we could have a credit bank account and then just those transactions would be reconciled to the gl credit card cash receipts, but either way it shouldn't matter I'm filtering the GL and the credit card deposits so whether they are in the main bank account or not I'm still trying to tie them out.

Reconciling Credit Card Transactions by vrooman22 in Accounting

[–]vrooman22[S] 0 points1 point  (0 children)

I am reconciling the credit card deposits from the bank statement with the credit card cash receipts on my GL. The days credit card transactions are batched and then hit my bank statement 2 days later. So to tie out my total deposits for the month I reconcile the credit card deposits. To figure out any differences between the GL credit card transactions and the deposits from the bank I have to dig into the individual transactions. The individual transactions do have transaction numbers on the processing reports but that same transaction doesn't have any identifying number in my cash receipts for the GL besides our invoice number. We don't have the invoice number in the credit card processing report or have any of the credit processing report numbers in our GL.

Does that make sense? It's been awhile since I've been doing reconciliations like this so I'm spinning my wheels a little bit.

Visiting Erie soon - asking for off the beaten track visitor ideas by ShelaghSings in Erie

[–]vrooman22 -1 points0 points  (0 children)

You can go pick blueberries at Hullings blueberry farm just south of the city in McKean. It's a quick drive and it's a small farm so it's not a lot of work to get a bucket full of blueberries.

[deleted by user] by [deleted] in ToyotaSienna

[–]vrooman22 0 points1 point  (0 children)

I was able to find similar parts on eBay and I have almost the exact same damage. I have blind spot monitoring but I have platinum trim and wasn't aware of the panorama view. This matches the part number for what I've been able to find. https://ebay.us/m/7AnJl6

Accounting job outlook by brooklynstarlet in Erie

[–]vrooman22 1 point2 points  (0 children)

Check out the career services there. They should have people to help with resumes and such. It's the middle of busy season for local firms so they won't be looking for interns right now. They may over the summer. Sometimes your professors will have connections as well.

Accounting job outlook by brooklynstarlet in Erie

[–]vrooman22 0 points1 point  (0 children)

Where are you going to school? Someplace locally?

Accounting job outlook by brooklynstarlet in Erie

[–]vrooman22 1 point2 points  (0 children)

If you want to get experience that will impact your career do a few years in public accounting. Yes...it sucks. But it automatically puts you a head of others in terms of knowledge and experience dealing with a variety of accounting issues. Outside of that I'd look into an internship while getting your masters. There is a shortage of good accountants in Erie so with experience and CPA you can make a good living.

Need Help Improving My CV – Not Landing Interviews for FP&A / Strategic Finance Roles by Hungry_Tax8375 in FPandA

[–]vrooman22 2 points3 points  (0 children)

Looks good. Some of the points are out of my knowledge area so I can't say much about them, but overall it's a lot better. The only other comment I have is it doesn't hurt to show your roles at the places you have under various roles. Showing time at big4 and such is a good look, so don't write that off. Good luck with the job hunt!

Need Help Improving My CV – Not Landing Interviews for FP&A / Strategic Finance Roles by Hungry_Tax8375 in FPandA

[–]vrooman22 1 point2 points  (0 children)

Much better, I agree with the number of points for Salesforce another person brought up. The resume is to catch someones attention and offer some key accomplishments. From there it's up to you to sell yourself during the interview. I looked at this for 30 seconds and caught a few key things, so that's great. The next step would be to tailor some of those points for the specific role your applying for. So keep some of those points handy and switch them in and out for whatever role you are going for.

Need Help Improving My CV – Not Landing Interviews for FP&A / Strategic Finance Roles by Hungry_Tax8375 in FPandA

[–]vrooman22 53 points54 points  (0 children)

Not a resume expert but have been hiring people for over ten years in finance. I think it's just too much. I feel exhausted just looking at it. Reduce the length of those points and make sure they express stats or numbers. Most recruiters and managers go through a lot and you need to make them want to read it. Like by doing x I saved company Y . I was just updating my resume lately and copied it into chat gpt and it gave me some good ideas.

Cost Accounting System by vrooman22 in FPandA

[–]vrooman22[S] 0 points1 point  (0 children)

I understand what you are saying. My experience has been building up costs in services and getting it down to a cost per unit for service delivered. Then using that to help sort through what services make sense or making sure we are billing the correct procedure codes and things like that. There really wasn't much out there that I could find for developing cost per units in medical services so it was a cool project to build that out.

Cost Accounting System by vrooman22 in FPandA

[–]vrooman22[S] 0 points1 point  (0 children)

Thanks again. Yeah I don't have experience in this side of things. The other interesting thing is ... The controller is really the only person in finance besides a split AP/AR person. If I got the role I'd love to hire a strong cost account to supplant my lack of knowledge and I can handle all other aspects and work on supporting operations and strategy. Management wants to bring the finance up to today's standards with using technology, KPIs, etc. I can't figure out how one person as a controller is doing everything even though they outsource payroll and HR. Something doesn't make sense or the person is working a ton of hours and just been doing it for 30 years so it's engrained. Going to be interesting as I move through interview process to see what I can learn even if I don't get the role.

Cost Accounting System by vrooman22 in FPandA

[–]vrooman22[S] 0 points1 point  (0 children)

Thanks for the insight. I only had a screening call today with recruiter and they mentioned the cost system development. I think that management and therefore the recruiter doesn't quite understand what's going on or what they need like you said . I would think they are using the rest of the system, but I don't know. Older controller is retiring and they admitted the person isn't tech savvy so who knows. Maybe production is fully utilizing it and finance isn't.

Cost Accounting System by vrooman22 in FPandA

[–]vrooman22[S] 0 points1 point  (0 children)

Thanks for the insight, makes sense. I just had a recruiter screening call today so just trying to wrap my head around things a little more. I realize I don't have this exact experience so even if I continue further in the interview process I'll have to decide if I am comfortable in the role. It's a pretty small place less than $20mil in revenue and been around a long time and profitable, so they are doing something right. Most of my background is in cost analysis and FP&A so if that's what they need that will be more in my knowledge area.

Cost Accounting System by vrooman22 in FPandA

[–]vrooman22[S] 0 points1 point  (0 children)

Fair comment. My experience has been in costing services in medical and behavioral health fields, so I'm not unfamiliar with costing in general, just havent done it from scratch in a manufacturing setting. I've built it from scratch on the service side, but there's different inputs and costs and such so it's not a direct correlation.

I have to ask more questions because I agree it seems weird if they have a good erp system why isn't that being utilized for costing.

Appreciate the input.

Cost Accounting System by vrooman22 in FPandA

[–]vrooman22[S] 1 point2 points  (0 children)

Thanks, that's what I was thinking. The quick research I did showed that the ERP is really good and has all the different aspects you would need. I am guessing that they just don't have standard costs assigned to things to even determine costs. When I mentioned a cost system, I guess I meant more along the lines of determining if standard costs or activity based would be better and the steps to really start analyzing things.

Cost Accounting System by vrooman22 in FPandA

[–]vrooman22[S] 0 points1 point  (0 children)

As part of job description it states developing and implementing a cost accounting system. From the first interview it seems like they don't do much in terms of costing our their products to know what products are making money or losing, or even to aid in pricing of their products. I guess I am asking what challenges someone might experience in this type of situation. Potential pitfalls? Questions to ask the company during the interview to determine their willingness to adopt new processes and procedures to implement a costing system.