how to create a column with debits and credits in one?

I am trying to upload csv files for accounting and need credit and debit transactions in one column. can anyone help me with a formula? I Have never done this before

iMac 27″ 5K, macOS 13.6

Posted on Sep 23, 2024 9:06 PM

Similar questions

How can I sum credit and debit columns for yearly accounts in Pages formulas? In Formulars in Pages I wish to Sum a column of Credit and Debit for every entry over a yearly account. How do I use Formulars to do this? [Re-Titled by Moderator]
567 4
How to import downloaded credit card transactions into a Numbers Spreadsheet I know that the easy way is to just download a csv file from the bank, double click it, and there you are. We've just been hit with the dreaded paperless banking though, so we no longer get a statement we can scribble on so that we can decide how much each of us needs to pay. So, every month I am downloading the current period's transactions, formatting the columns appropriately so that it can be sorted into date sequence, adding an extra column so that we can add the responsible party's name, then adding additional rows so that it will produce totals for each person (sumif). So, an hours work or more before we can start putting our names against the appropriate transactions I'm thinking that there ought to be a way to use the formatting that I already have, e.g. using a template. The only way I know of getting a csv file into a spreadsheet is to double click it and create a new spreadsheet so how would I import the data. It's a different number of transactions each month though so how would that work? Can anyone help or point me to something similar?
2377 4
Numbers formula for adding up several spreadsheet totals All my money goes into my bank, but, each fortnight I allocate sums to various expected bills and I have a Numbers sheet for each category. That sheet records funds in, funds out and a running balance calculated automatically. I then sit with a calculator and add up all those totals to check against my bank balance How can I get Numbers to do that for me, automatically as I enter debits & credits on each sheet? TIA
406 4

3 replies

Yellowbox

Level 7

21,987 points

Sep 23, 2024 11:48 PM in response to Yellowbox

Hi Belinda,

Thanks for the screen shot.

Formula in F2 (and fill down) is E2−D2

Sorry, I don't understand how the Balance is calculated.

Regards,

Ian.

Yellowbox

Level 7

21,987 points

Sep 23, 2024 10:27 PM in response to belinda_for

Hi Belinda,

There are as many ways to do this as there are different .csv formats and layouts.

Please post a screen shot of part of your csv table. Include column headings. Delete or hide personal details.

Regards,

Ian.

belinda_for Author

Level 1

4 points

Sep 23, 2024 10:42 PM in response to Yellowbox

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

how to create a column with debits and credits in one?