P&L treatment of debit / credit accounts

For the P&L Report to work the way you want, you’ll need to stick with the convention of expenses being negative in your Transactions sheet. If you are importing transactions manually via CSV with a bulk import template, I’d consider making the import-ready Amount column derived off of the raw Amount from your data source. The derived version can then manually or via-formula flip the sign on credit card transactions.