accounting

Hi Guys I am sort of good at using excel for finance function for my job purpose. However I have come across some VBA enabled excel sheets which do excellent job. I would like to learn how to code VBA. I have started reading a book on VBA learning. It would be great if you can give me some...

<tbody> <tbody> Units </tbody> <tbody> COGs (each) </tbody> <tbody> Total COGs </tbody> <tbody> Desired Margin </tbody> <tbody> Revenue (sell price) = COG/(1-m) </tbody> <tbody> Markup in percentage (?) </tbody> <tbody> 1,000 </tbody> <tbody> 5.00 </tbody> <tbody>...

Hey! I am a tax accountant trying really hard to impress my manager...long story short one of our big clients give us a very un organized Excel sheet of there trial balance... and I want to find a quick way to organize it...below is an example of what the excel looks like and what I want to...

<tbody> <tbody> Location Project DISCIPLINE NAME Total Hours A 1 xxx John 1 A 1 xxx John 1 A 2 xxx John 3 A 1 xxx Jane 5 B 1 xxx Jane 5 B 2 xxx Doe 2 B 2 xxx Doe 2 </tbody> How could I consolodate a similar report by taking values in the...

I've used Excel off and on for several years, and I'm frustrated that I just can't figure out how to accomplish what seems like a very simple task. Let me explain... I have a single sheet where I register all financial transactions for my business (revenue, expenses, everything). I have a set...

Hey guys, I've done a bit of searching and have found a lot of great info on the forum, but nothing that quite answered all of my questions. If I somehow missed a forum please direct me there. I have a workbook I've created for my wife's floral business. As of right now, it takes care of the...

Scenario:<o:p></o:p> I obtain a CSV file from the accounting system summarizing budget and expense amounts by project grant (i.e. departments) by G/L account. The problem is that it needs to be “cleaned-up” before I can utilize it as it is more like a report than a data table.<o:p></o:p>...

Can anyone direct me to a site where I can find a free temp;late for a Access template for Gneral Ledger/lLedger and project accounting? I need to be able to input various types of transactions against budget line items on a project basis and then have it reflect on an overall division ledger...

I have copied over a row of $, ($) amounts from one worksheet to another. I am trying to make the amounts I copy over past in absolute values. Is there a way to do this? Below is the current code: 'copying over the Amount in Local Currency ST Reclass Sheets("Recon_ST").Select...

Hi, If I have an amount, which should be accrued due to a start date and end date. How could this be done? I've tried to read about accrual accounting, but I can't find any simple examples on just simple linear accrual.

I am looking for an Excel Template for a property investment company that can help with the consolidation process. Can anyone help:)

I have the following issue where i have to analyze actual bookings, and ensure they follow the allowed combination criteria. How can i make an excel vlookup/macro which compares the actual bookings to the allowed combinations, and if they dont meet the allowed criteria, returns an N/A? Actual...

I am trying to format a report field to accounting (called the accounting format in Excel, not sure about Access). In particular, I'd like the zero values to show as dashes (hyphens) rather than 0. My report is based on a query. I have searched the board and google results and cannot find...

Hello all, At some point or another , I somehow managed to download/install/set up a tick mark system I found on the web from someone named Mark Lehman. This system is tied to your personal.xls file and works with macros and .bmp files that have been created to symbolize the tick marks I am...

Hey guys, I've got another question, this one macro related. In a spreadsheet for my class looking at asset depreciation forecasts, the "Book Value" column goes negative at a certain date, and I need it to just go blank instead of displaying a negative accounting value. How can I write a...