Stack Overflow
Stack Overflow

Questions tagged [accounting]

Systematic recording, reporting, and analysis of financial transactions of a business.

357 questions
-1
votes
1 answer

PHP Round up long float to two decimals in accounting

Say you have this number 562.9444445 and you want to round it up to 2 decimals. Now I would say that the result would be 562.95 as the 5 is carried up from the tail. No? Well, the PHP round function does not work like that. It will just check the…
drew7721
  • 1,622
  • 18
  • 20
-1
votes
2 answers

How can i get value of saldo (debit - kredit) Laravel-MySQL

How can i get the value of saldo? Saldo = Debit - Kredit Im using laravel and MySQL, am i doing the counting in controller or in sql query?
fahmi zikrul
  • 7
  • 1
  • 5
-1
votes
1 answer

ISSUE IN EQUATIONS

I have to find out margin profit from some values, but in many of the cases profit coming as negative value based on the calculating values. How can I adjust the variables to keep profit always positive value 1) GoGet = (Go / 100) * (Get / 100) …
sarin
  • 35
  • 8
-1
votes
2 answers

Calculate Gross Profit W/O Sell

Trying to make myself a small project for work that will calculate gross profit without needing a sell price. Can anyone explain why this is getting marked down? we all needed help at one point.. I currently have 4 text boxes, Cost, Sell, Gross…
junior
  • 13
  • 5
-1
votes
3 answers

Join Multiple Select queries with where clauses for each

So I have a series of Amortization schedules, and I'd like to run a query to return the balances for the month of May on each schedule My query right now, looks something like this select ace.date, ace.balance, aacs.date, aacs.balance, axl.date,…
Danielle
  • 13
  • 4
-1
votes
1 answer

PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

I am struggling to figure out why this code isn't compiling. the exact error im getting is: ERROR at line 82: ORA-06550: line 82, column 4: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ( begin case declare…
Ryan Jolly Young
  • 11
  • 2
  • 7
-1
votes
1 answer

Need a macro to sum all GL accounts while excluding a few specific GLs

I need a macro that sums all of column H excluding Account #s 52202001 and 51701001 (from column F). I know I could use this formula =SUMIFS($H$15:$H$12729,$F$15:$F$12729,"<> 52202001", $F$15:$F$12729,"<> 51701001") But I would like it in a Macro…
Brad
  • 1
  • 2
-1
votes
2 answers

Is there a script to parse radius accounting flat files for export to seperate mysql server

I have been searching for an answer to import flat files for radius accounting records into a seperate MYSQL server (not hosted on the same radius server). We have months worth of reply-detail logs, auth-detail logs and detail logs from 4 different…
Mila
  • 1
  • 1
-1
votes
1 answer

Balance transacctions made before converion date

I am setting up new accounting software, and I want to include some expenses that happened before my conversion date. If I debit them to an expense account, where do I record the credit to make it balance? I cannot credit the bank account as that…
TinyTiger
  • 1,801
  • 7
  • 47
  • 92
-1
votes
1 answer

Find Excel three-columns match in two different sheets

I've three sheets from differents periods of several companies It happens that not same accounts were used on all periods. I need to compare two or three companies from two different periods. I've managed to pull out the data from any company on…
Chat Cubano
  • 1
  • 4
-1
votes
1 answer

divide the money value to zero?

i have a problem to divide the money value to "0". i build accounting software, with a shrinking asset. example, i have a value 1000000. i would divide it into 3. 1000000 / 3 = 333333,33333333333333333333333 the question is, i would to do…
APL
  • 3
  • 2
-1
votes
3 answers

Excel: Computing Regular Deposits for a Specified Future Amount

I had tried to run some example from my calculator on excel. I cannot get the correct answer of 203.13. Can someone try to pinpoint the error in my formula? You plan to open a savings account and deposit the same amount of money at the beginning of…
NHK
  • 1
  • 1
  • 3
-1
votes
2 answers

Use SFDC instead of spreadsheet

Below is a spreadsheet where I would like to transfer to SFDC. https://docs.google.com/spreadsheet/ccc?key=0ArjzY2lGAEAFdHdoc1ZERDlVRHZBRzlxRlJPQ0RPSVE&usp=sharing Basically, I would like to insert the daily sales and expenses. Once I input the…
Friday Landon
  • 39
  • 1
  • 5
  • 10
-1
votes
1 answer

About client/server Peachtree Accountant software

We plan to setup client and server for peachtree accounting system. currently, we have software Sage Peachtree Quantum 2010 Accountant, so could we use this software for making client and server? Do you have any ideas regarding this issue?
Dara Viro
  • 11
  • 1
  • 4
-1
votes
2 answers

Excel formula that multiplies the value of a cell times 2 only if it is under $.99

Hello and thank you for your help! I am writing a formula to help me calculate coupon deals for my shopping trip. My store doubles coupons $.99 or under, so I need a formula that does the following: If the value in cell D2 is less than $1.00,…
meowmers
  • 129
  • 3
  • 13
1 2 3
…
23
24