Super User
Super User

Questions tagged [accounting]

Accounting is a function of an organization that produces financial records. These questions are related to utilizing software to complete accounting tasks

Accounting culminates in the production of financial records such as balance sheets, income statements, statement of cash flows and the like. Accounting can also refer to any type of financial analysis (reporting, budgeting, identifying trends) in both up-stream and down-stream functions of business.

36 questions
16
votes
4 answers

How to move Mint transaction data to GnuCash

Online financial aggregators are great for getting transactions from all of your accounts into one place, but the accounting tools they provide are pretty minimal. I'm a Mint user, and I like the idea of letting Mint manage the connection to my…
i did not pay the royalties
  • 412
12
votes
2 answers

How do you reverse the sign of a range of numbers in Excel?

In accounting I sometimes download statements where although the transaction represents debit, the sign is negative. I then need to change the sign to be positive so it's actually indicating a true debit/withdrawal from the account. How can I easily…
deed02392
  • 3,132
  • 6
  • 30
  • 36
4
votes
2 answers

Looking for a opensource, web based, double entry accounting system

I need some accounting functionality for an existing web based system and are trying to find an open source web based accounting package with which I can integrate instead of writing the functionality myself. It should preferable be LAMP based. I…
Hannes de Jager
  • 427
3
votes
1 answer

Time and expense registration tracking tool

I am currently using a program named WorkBook - and am now looking for a cheaper replacement. Preferable free - open source software! I only use the time registration and expense registration parts of the system for my customers so that parts will…
Rikke Holten
  • 31
  • 1
2
votes
2 answers

What type of dataset am I working with here in Excel? What word or term can best describe it?

I am beginning to delve into data analysis via Excel and I would like to learn more about the terminology in terms of some data I'm playing with. I've created a sample data set for mock invoice charges with different products per invoice listed as…
devindj6932
  • 21
2
votes
1 answer

Devising Excel Spreadsheet Formulas

I'm using Excel for the accounting purposes of a group venture, to keep track of our expenses, costs, payments, and balances. Details of each expense are stored in columns A:J Total costs and balances are stored in columns K:M Payments and dates…
oldboy
  • 413
  • 2
  • 6
  • 21
2
votes
3 answers

Make gnucash to track something other than money

How to make gnucash track something other that national currencies and securities, for example, DVD-RW Discs, books and other things I can lend to people. I want to know who owes me some discs and where should I return lent ones. They also can have…
Vi.
  • 17,755
2
votes
2 answers

How do I use Excel to categorize bank transactions into easily understandable categories to see where my money is going?

My boss wants our bank transactions categorized manually. Right now my task is to go through the bank transactions and categorize them into categories based on what each item is. For random expenditures (one time only) it makes sense to look it up…
Pulse
  • 351
2
votes
2 answers

Accounting software for a USA based small tech company

I just registered my .com business as an LLC. Which means I need to start paying taxes and do real accounting. I have an MSDN license so I have access to all Microsoft software. however it looks like they don't offer a Quickbooks style software…
user25785
  • 59
2
votes
1 answer

How to change default Accounting Number Format?

In most cases, the default accounting format in Excel is $ Without using some kind of macro Without changing timezone (or other system settings) of the computer How to change this and set another currency as default using Excel's built-in…
Mr.X
  • 161
1
vote
2 answers

How can i send Automatic Invoices to my customers every month

I want to send my customers automatic invoice every month. Is there any online website which can do that. OR any plugin or script i can put on my own server to generate it Automatically
Mirage
  • 3,303
1
vote
1 answer

Data reconciliation with pivot table

I have 2 tables (table1, table2), each with 2 categorical variables/columns (product, country) and up to 5 real-valued variables to be reconciled/compared against each other (sales and other in the example below). Datasets can have unique…
user453425
1
vote
1 answer

The FINISH button on GnuCash Account Reconciliation is greyed out

This is my first attempt at using GnuCash to reconcile checking account. I've checked the transactions that appear on statement and the green check appears in the 'R' Column. According to GnuCash Help manual, since this is my first reconciliation my…
zundarz
  • 1,163
1
vote
1 answer

How can I modify tables and forms in a MS Access database using UA Business Software 7.0?

I need to make changes to table structures and forms on a MS Access database using UA Business Software 7.0 The problem is that UA hides everything and everything is locked.. It doesn't even look like Access anymore! Has anyone had this problem…
Shawn
  • 1,361
1
vote
3 answers

Importing statements into Quickbooks

How do I import the following statements into Quickbooks Pro? Bank of America American Express
Raj More
  • 951
1
2 3