accounting

Hi all! I am making an accounting spreadsheet that auto generates practice problems for students that I tutor. I have most everything done, but I need a way to generate the actual numbers (randomly each time) for each account, but still have my assets equal to my liabilities/equity. So...

Good afternoon, I want to make an auto increment in my cell formula. The idea is every time I put a check mark , it will increase by 1. For example: <colgroup><col><col><col><col><col></colgroup><tbody> 10/16-12/16 350,000.89 =-116,666.96*2 ($116,666.96/ month 2 of 3)...

Hi All I'm hoping you may be able to help with an issue I'm experiencing when trying to create a multi-level doughnut chart using Excel 2013. It's a work project and I've modified an existing file that contains all of the income and expenditure during a month. It tracks a variety of data...

I work in grant budgeting and need to calculate fiscal year budgeted amounts based off of calendar year budgets. Usually the amount of calendar year days hits multiple fiscal years. See below; <tbody> Calendar Year Total Days Fiscal Year Total Days Days in CY 365 350 0 715...

Hi, I work as an accountant and am attempting to use financial data to create rolling balances. I have two Fact tables connected with various Dim tables. The first Fact table contains trial balance data at a given point in time i.e. end of month. The second table contains transaction data...

Thank you for taking the time to read this thread. Please help me keep this thread neat and useful to others by not posting anything that detractgs from the objectives It is about Accounting programs and systems being created in Excel VBA. It covers file management fundamentals; Double entry...

I'm trying to get a formula for current deprecation that depreciates monthly but I cant seem to figure it out I have it depreciating yearly at the moment. Can anyone see on my formula that I can tweak? =IF(AND(Life>0,LEN(Life)>0,[Acquisition Cost]>0,[Acquisition...

Hi guys, I have a billing sheet, looks roughly like the one below. At the bottom of the cost column is a total that tells me how much to bill a client for a particular job, based on the hours worked and the cost of those hours. However, if any individual does more than 80 units of work on a...

Hello, I would like a Macro that will look for "A" next to a journal entry and copy the items to a new worksheet within the same workbook and transpose the account numbers & Item descriptions vertically.Any help would be greatly appreciated! Thank you! This is how the template looks...

Hey all, I'm attempting to create a formula that will automatically search and paste the new account structure with the old. In short, the "location" in the new structure is different from the "location" in the old structure. The new location is determined by the old location account number...

i want to calculate the no. of working days of employees. and situation goes this way: ENTER joining date in b2 ENTER leaving date in b3 and result displays in some cell. [Working days in a year is 313 or a year will be counted as 313]

I was wondering if anyone knew of a way to create a spreadsheet that would allow someone to enter an invoice date and have Excel automatically calculate payment terms of 2% 10th net 25? Example: Customer is invoiced 7/24. They must pay by 8/10 to get the 2% discount. Payment is due in full on...

Hi everyone, I am new to Vlookup and am comparing two columns in one spreadsheet tab to multiple columns of data in another tab. If the data is found in the second tab, then return the 6th column in the second tab. For instance, The first tab, cell C2 contains transactions, cell E2 contains...

Hello, say I have multiple invoices that are all made the same way. Different VAT tax codes are invoiced. Total invoice = amount without tax + tax. These different VAT codes go into different rows in a second tab that specifies the tax code. For example: <tbody> Site ID Document Date Doc. Nr...

Hi, I know similar questions have been asked. I did search the forums but was unable to find a solution for my particular problem. Essentially, i want to compare transactions on a CSV exported file from my bank to the Fee paid on my business spreadsheet. The problem is that the CSV file...

Hi, I am relatively new to Excel. I use it mainly for accounting, and realised that I was spending a lot of time doing repetitive highlighting of cells and copy/paste. I know the basics of programming so I'm prepared to dive in at the deep end. What I would like to do is the following: search...

Hi all. New to the forum - thanks for existing. Looking forward to sharing my knowledge too. Now - I have two individual sheets of 19.000 rows in one column. Sheet one is ingoing payments. (Positive numbers) Sheet two is (similar) outgoing payments. (Negative numbers) The sum of a sheet's...

Sheet in 2010 won't accept Accounting format. But it's not locked and not protected against formatting. Data appears left flush with no symbols. When new rows or columns are inserted, won't format these either. Other sheets in workbook are fine. Would appreciate any suggestions. :confused:

Hello, I have text data in column A and the corresponding Numeric(the debits) in column B. Also have text data in column C, and it's corresponding numeric (the credits) I'm column D. The data in Col C have more than one corresponding entry to Col A at times. How do I get Col A to match its...

I am working with journal entries. I am trying to find the unique numbers in a cell that also contains words. I am unable to upload the excel spreadsheet due to it being financials. But I can give examples. Here is are some examples: 2000 carpet clean for makeready. repair planking 1884. 2N205...